Forum Discussion
Logical Formula
=IF(AR15="outstanding",2500,IF(AR15="exceeds",2000,IF(AR15="meets",1500,0)))
This formula has no identified errors but the last argument returns 0 instead of 1500. outstanding and exceeds work fine. Appreciate any thoughts.
3 Replies
Check very carefully whether there is a space after (or perhaps before) the word "meets" in AR15.
If AR15 contains "meets " (without the quotes), the formula will return 0.
In addition, comparison is case-sensitive, so if AR15 contains "Meets", the formula will also return 0.
- Thank you. Your reply says "If AR15 contains "meets " (without the quotes), the formula will return 0". I want to return 1500 and only return 0 if anything other than outstanding, exceeds, or meets appears in AR15. Is it not structured to do that?
Look closely: "meets " in my previous reply has a space after the s. That would cause the formula to return 0 since "meets " is not equal to "meets".
If you cannot find the cause of the problem:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
