Forum Discussion
Solved
IF statement with OR and NETWORKDAYS
Hello I have some trouble adding the OR function to this statement:
=IF(AD3="","",NETWORKDAYS(AC3,AD3))
So far I am saying that if AD3 is blank then the result should be blank otherwise the resul...
Nikoss I believe you have bracket in the wrong place. Try it this way.
=IF(OR(AD3="",AF3="Yes"),"",NETWORKDAYS(AC3,AD3))
Riny_van_Eekelen using the same principal how would I use this if I were to calculate my networking days from TODAY and past dates?
hezb158 This thread was about how to write an OR function. Better to start a new thread with your own question relating to the NETWORKDAYS function.
- Thank you so much it works now!
