Formula is returning FALSE and I need it to return 0

[Captain Hindsight]

Hi,

This should be a quick one for somebody but I can't figure out why this is happening.

Here is the formula:

=IF($C5>0,IF(COLUMNS($A:A) < ROWS($1:1),0,IF(COLUMNS($A:A) < 3+ROWS($1:1),IF(COLUMNS($A:A)+ROWS($1:1)=2*ROWS($1:1),0,'Unbalanced cost calculations'!B$50))),0)

which I need to return 0 if false.

Thanks

 

[Andrew Poulsom]

Try:

=IF($C5>0,IF(COLUMNS($A:A) < ROWS($1:1),0,IF(COLUMNS($A:A) < 3+ROWS($1:1),IF(COLUMNS($A:A)+ROWS($1:1)=2*ROWS($1:1),0,'Unbalanced cost calculations'!B$50),0)),0)

You can use the Evaluate formula tool to see why your formula is returning FALSE.

 

[Captain Hindsight]

Great, thanks