IF sum is GreaterThan 0... why wont this work!?

[Tan.]

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.

 

[SteveG]

Tan,

Try this.

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

Does that help?

Steve

 

[Tan.]

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.

 

[Harlan Grove]

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.