Software

Ask something
Question Locked

Excel Nested IF

0 helpful
2 replies

by mslwill

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

2 replies

by 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

This discussion is closed to new replies.