Forum Discussion
Nikoss
Nov 02, 2020Copper Contributor
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...
- Nov 02, 2020
Riny_van_Eekelen
Nov 02, 2020Platinum Contributor
Nikoss I believe you have bracket in the wrong place. Try it this way.
=IF(OR(AD3="",AF3="Yes"),"",NETWORKDAYS(AC3,AD3))
Nikoss
Nov 02, 2020Copper Contributor
Thank you so much it works now!