View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
cfiser
 
Posts: n/a
Default display actual number or zero, whichever is greater

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