This is what I think should work
=IF((GREATERTHAN((G56-L4-N6),0)),0,(G56-L4-N6))


But it doesn't.

If the sum is in minus figures I simply want the cell to display 0
Surely not that hard!?

Any help much appreciated.
Thanks

Tan.


--
Tan.
------------------------------------------------------------------------
Tan.'s Profile: http://www.excelforum.com/member.php...o&userid=30616
View this thread: http://www.excelforum.com/showthread...hreadid=502666