Thread: display actual number or zero, whichever is greater
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default display actual number or zero, whichever 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
Reply With QuoteReply With Quote