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
This conversation is currently closed to new comments.
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
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Nested IF