Break Even Point Formula

marstonk

Active Member
Hi I am trying to get row 363 to return a number 1 when a project pays back its borrowing. Here I have a formula to return value 0 or 1 it works on other spreadsheets with the same data and format but does not work here. Can anyone help me?
MT Model_Templatev3with SHG repaid.xls
EFGHIJ
359-----199.9
360
361
362
363------
364------
MT Analysis

Thanks,
kittyg

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
This is one way:
Book1
ABCDEFG
4projectCF(10)5511
5
6check---1-
Sheet1

Tell if it works for you.

Hi there

Yes that works thanks, Just to advise if your interested my original formula only works when a cost appears before a revenue stream bizarre I think I am loosing the plot today!!

Ta

kittyg

Yes you are right.
Which is why I suggested my formula, which looks at
the 'current' row for it's second argument.
btw, to make it even nicer, add a row/header with the running
date and multiply the first argument by it.
As in, (SUM(\$B4:C4)>0)*C2*(SUM(\$B6:B6)=0)*1

another btw, you can drop the "*1" at the end of formula.
not needed.
Cheers.

Replies
3
Views
81
Replies
2
Views
215
Replies
2
Views
109
Replies
2
Views
318
Replies
1
Views
102

1,203,462
Messages
6,055,563
Members
444,799
Latest member
CraigCrowhurst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back