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