display actual number or zero, whichever is greater

cfiser · Dec 2, 2005

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

David Billigmeier · Dec 2, 2005

=max(D35-H21,0)

Peo Sjoblom · Dec 2, 2005

=MAX(D35-H21,0)

SteveG · Dec 2, 2005

This should work.

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

Cheers,

Steve

cfiser · Dec 2, 2005

THANK YOU, THATS WHAT I NEEDED

David Billigmeier said:
=max(D35-H21,0)

cfiser · Dec 2, 2005

THANK YOU, THATS EXACTLY WHAT I NEEDED

Peo Sjoblom said:
=MAX(D35-H21,0)

--

Regards,

Peo Sjoblom