Thread: Change Negative Numbers to 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sherry N. Sherry N. is offline
external usenet poster
  
Posts: 15
Default Change Negative Numbers to 0
I have a cell that calculates how many business days between two dates
=NETWORKDAYS(B3,C1).

If that formula produces a negative number I would like the value of the
cell to be 0 "zero".

Any suggestions?
--
Sherry N.
Reply With QuoteReply With Quote