Questions

Excel Nested IF

+
0 Votes
Locked

Excel Nested IF

mslwill
Please tell me why this IF statement won't work completely? =IF(B2=5,"Exceeds Expectations",IF(3,"Meets Expectations",IF(1,"Needs Improvement",IF(" "," ")))).The first two arguments work, but the last two do not. Can someone please advise? Thank you
  • +
    0 Votes
    cleaverx

    I am sorry I don't have a ready answer for you, but you will probably have a better chance of someone good with VBA helping you out if you explain in details what exactly is that you are trying to accomplish with this formula. It just may be that the approach itself needs to be revisited.
    Best regards

    The Cleaver

  • +
    0 Votes
    cleaverx

    I am sorry I don't have a ready answer for you, but you will probably have a better chance of someone good with VBA helping you out if you explain in details what exactly is that you are trying to accomplish with this formula. It just may be that the approach itself needs to be revisited.
    Best regards

    The Cleaver