Question

  • Creator
    Topic
  • #2170976

    Excel Nested IF

    Locked

    by 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

All Answers

  • Author
    Replies
    • #2888389

      Clarifications

      by mslwill ·

      In reply to Excel Nested IF

      Clarifications

    • #2888312

      Excel custom function

      by cleaverx ·

      In reply to Excel Nested IF

      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

Viewing 1 reply thread