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

=max(D35-H21,0)

--
Regards,
Dave


"cfiser" wrote:

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

=MAX(D35-H21,0)

--

Regards,

Peo Sjoblom

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

This should work.

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

Cheers,

Steve


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

THANK YOU, THATS WHAT I NEEDED

"David Billigmeier" wrote:

=max(D35-H21,0)

--
Regards,
Dave


"cfiser" wrote:

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

THANK YOU, THATS EXACTLY WHAT I NEEDED

"Peo Sjoblom" wrote:

=MAX(D35-H21,0)

--

Regards,

Peo Sjoblom

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