View Single Post
  #5   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

Perfect! Thanks so much!
--
Sherry N.


"Chip Pearson" wrote:

Sherry,

Try

=MAX(0,NETWORKDAYS(B3,C1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Sherry N." wrote in message
...
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.