Posted to microsoft.public.excel.programming
|
|
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.
|