IF Formula returning False

Hello & Happy Thanksgiving to everyone out there!

My If formula is returning false and I am in need of guidance. I have been searching the boards for an answer and I am either not technical enough to understand it or I just simply haven't found my answer. I have users selecting a rating from a drop down box once they select the rating the next column would return a value that is assigned to that rating. Unfortunately that is not happening. Rather it is returning as false. Below is the formula I am using - which is clearly wrong! Help?!

=IF(A1="FE",4,IF(A1="ER",3,IF(A1="AR",2,IF(A1="IR",1))))

Thank you for your quick reply. I actually I was getting false even with a rating in A1. I did try your suggetion above and now while it no longer returns as false it is blank even with a rating assigned in A1

Interesting... so I did go back and look at that. Where I had my list of ratings I went back to ensure I had not accidently hit the space bar after entering the rating. I then went to my drop down list and removed my data validation and created a new list - just to be on the safe side. When I did that and selected ER from the drop down it assigned the rating value of 3 which is correct. However, when I selected any of the other three ratings (FE, AR or IR) it would not return the correct rating value it remained a 3.

Perhaps I should mention that in my list that I pull from to creat the drop down list I do not have "FE" only FE and same with the other ratings. Should I try the formula without the " "? I was taught that I needed to incase the rating with " " when using this formula.

Sure - I hope this makes sense....

Calculation options are on manual...

When I open the book you posted, you have Calculation Set to Manual.

So I just noticed that when I save the document the rating value corrects! It just doesn't happen when I enter in a different rating.

Oh my goodness!!!! That's it!

ConneXionLost - thank you very much for your time, knowledge and help! I truly appreciate it. I didn't even think about looking at my calculation options! Not sure why!!!!

Jonmo1 - thank you for your insight as well... I have spent two days working through the formula thinking it was something wrong with it - but knowing there wasn't! Truly appreciate it.