display actual number or zero, whichever is greater

[Guest]

I need to have a cell display a number or zero whichever is greater.
example:
D35-H21 OR ZERO WHICH EVER IS GREATER

 

[Guest]

=max(D35-H21,0)

 

[Peo Sjoblom]

=MAX(D35-H21,0)

 

[SteveG]

This should work.

=IF(D35-H21<0,0,D35-H21)

Cheers,

Steve

 

[Guest]

THANK YOU, THATS WHAT I NEEDED

=max(D35-H21,0)

 

[Guest]

THANK YOU, THATS EXACTLY WHAT I NEEDED

=MAX(D35-H21,0)

--

Regards,

Peo Sjoblom