GPA calculator

[kovachattack]

Hi,

I am trying to make a GPA calculator so that I know how well I have to do on my finals. I have one that works, but I would like to make it a bit simpler. As of right now, I have one column where I put my grades (B, B+, etc) and in the column next to it, I put the grade points for that class (3.0, 3.3333, etc) where I can then use those numbers for calculations. Is there a way I can have the second column display the proper number as a function of the first column; as in, if I type in 'A' in the first column, it will put '4' in the second, if I put 'B-' in the first, it will put '2.6666' in the second. I know I can just do this manually, but I am lazy and I am also seeking to increase my excel knowledge. Thanks!

[zbor]

Something like this?

Book1.xlsx

[kovachattack]

This is exactly what I was looking for, thanks!

[zbor]

Don't forget to make this thread [solved]

Edit: You must define somewhere all grades (like F and G here). Can be on other sheet..