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

Tan,

Try this.

=IF(SUM(G56-L4-N6)<=0,0,SUM(G56-L4-N6))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=502666

SteveG wrote...
Try this.

=IF(SUM(G56-L4-N6)<=0,0,SUM(G56-L4-N6))

Does that help?

Why use SUM? Why use IF?

=MAX(0,G56-L4-N6)

should produce the same result.

Thanks, it did help albeit indirectly.

After a few trials and errors juggling it about I decided to do the SUM
in a seperate equasion and ended up with this which worked:

=IF(M6<=0,0,M6)

Thanks again
:)
Tan.


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