Break Even Point Formula

[marstonk]

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
	E	F	G	H	I	J
359	-	-	-	-	-	199.9
360
361
362
363	-	-	-	-	-	-
364	-	-	-	-	-	-
MT Analysis

Thanks,
kittyg

 

[luckycharm]

This is one way:

Book1
	A	B	C	D	E	F	G
4	projectCF		(10)	5	5	1	1
5
6	check		-	-	-	1	-
Sheet1

Tell if it works for you.

 

[marstonk]

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

 

[luckycharm]

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.