Captain Hindsight
New Member
- Joined
- Oct 9, 2013
- Messages
- 46
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
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
Last edited by a moderator: