IF statement with OR and NETWORKDAYS

[Nikoss]

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 result should be the number of business days between AC3 and AD3.

Now I also need the result to be blank if AF3="Yes" so I tried =IF(OR(AD3="",AF3="Yes",""),NETWORKDAYS(AC3,AD3)) but I get #VALUE!

The correct results should be:

If AD3 is blank and AF3 is "Yes" The result should be blank

If AD3 is blank and AF3 is "No" The result should be blank

If AD3 is NOT blank and AF3 is "Yes" The result should be blank

If AD3 is NOT blank and AF3 is "No" The result should count business days between AC3 and AD3

What am I doing wrong? I have attached a screenshot of the spreadsheet for more help.

[#2]

@Nikoss I believe you have bracket in the wrong place. Try it this way.

=IF(OR(AD3="",AF3="Yes"),"",NETWORKDAYS(AC3,AD3))

[#3 · Accepted solution]

@Nikoss 

Use

=IF(OR(AD3="",AF3="Yes"),"",NETWORKDAYS(AC3,AD3))

[#4]

Thank you so much it works now!

[#5]

Thanks a lot! That works!