IF and NOT function question

**Bonnie Haring** · 03-19-2010, 10:11 AM

I need help with a nested IF function. What I am trying to do is if J9 is blank and if K9 is not blank then I want it to be 0, other wise I want the networkdays between J9 and M9 minus our list of Holidays.

My current formulas is

=IF((J9=""),0,IF(NOT(K9=""),0,NETWORKDAYS(J9,M9,Holiday))-1)

This is working where K9 is blank but if K9 has a date I am getting -1 where it should be 0.

**zbor** · 03-19-2010, 10:17 AM

What is this -1?

You can try use this: =IF(J9="", 0, IF(K9="", MAX(0,NETWORKDAYS(J9,M9,Holiday))-1, 0))

**Bonnie Haring** · 03-19-2010, 10:28 AM

The -1 has something to do with no figuring in the weekend. I found this last year and really do not remember the reason behind it but it works for what I need and I tried your formula and it seems to work. Thanks for your help.