 # Nested IFs

• Hi,

I'm sure there is a really obvious answer to this but I've tried a ton of combinations with nested ifs, if ANd,IF OR and I'm stuck. Keep getting the error too many arguments for this function..

I'm trying to get it to do this :

=IF(B2="",'"WORKDAY(D2,10)),IF(B2="EXAM",(WORKDAY(D2,15))

(Sorry if my () and ""s are wrong )

So basically if

Column B has no value keep the row blank

If it does column E adds ten workdays to the date in column D

but if column B = exam I want it to be 15 workdays to not 10..

Any help would be much appreciated! • I think you mean this:

=IF(B2="","",WORKDAY(D2,IF(B2="EXAM",15,10)))

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• Glad to help. Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why