Excel Forumla help (IF formula) [Solved/Closed]

Report
-
 pleasehelp1101 -
Hello,

I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grade of a B in one column and then in another separate column it automatically produces a 3. Also, I need each column to be flexible so that if I get an A in on course, then the corresponding column next to it will produce a 4 in it. I am trying to make a spreadsheet to keep track of my ongoing grades and I am stuck on this step. Thanks for the help in advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
in that column where you wants the digits to appear, you need to use this sort of formula

=IF(A1="", "", IF(A1="A", 4, IF(A1="B", 3, IF(A1="C", 2, IF(A1="D", 1, IF(A1="F",0,"Invalid Entry"))))))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


Thank you so much, you helped so much! It's all done now!