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