Forum Discussion

Copper Contributor

Nov 02, 2020

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...

BI & Data Analysis

excel

Formulas and Functions

HansVogelaar
Nov 02, 2020
Nikoss

Use

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

HansVogelaar

MVP

Nov 02, 2020

Nikoss

Use

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

Nikoss

Copper Contributor

Nov 02, 2020

Thanks a lot! That works!