Excel Forumla help (IF formula)

Solved/Closed
pleasehelp1101 - Feb 22, 2010 at 01:54 AM
 pleasehelp1101 - Feb 22, 2010 at 04:07 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 22, 2010 at 06:11 AM
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
pleasehelp1101
Feb 22, 2010 at 04:07 PM
Thank you so much, you helped so much! It's all done now!
0