Change Negative Numbers to 0

[Guest]

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?

 

[Chip Pearson]

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)

 

[Guest]

Perfect! Thanks so much!
--
Sherry N.

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)

 

[Guest]

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

 

[Dave D-C]

How about
=IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1))
D-C

 

[Chip Pearson]

=IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1))

In most cases, that would call NETWORKDAYS twice, adding unnecessary
overhead to the calculations.