View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default display actual number or zero, whichever 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