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 :


    (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:


    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