How to make letter grade in one column equal a number in another?

Kraner

New Member
Should be simple, just blanking today.

I have a mixture of A, A-, B+, B, and B- in one column and would like to correspond them to 50, 40, 30, 20, and 10. It would be great if I could change the corresponding numbers easily too, just incase.

Thanks!

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hi, you could create a lookup table and use VLOOKUP() for example:

Excel 2012
ABCDE
1A-40A50
2A-40
3B30
4B-20
Sheet1
Cell Formulas
RangeFormula
B1=VLOOKUP(A1,\$D\$1:\$E\$4,2,0)

Another option:

=CHOOSE(MATCH(A1,{"A","A-","B+","B","B-"},0),50,40,30,20,10)

Quite handy! Thanks!

Replies
0
Views
663
Replies
3
Views
776
Replies
5
Views
393
Replies
7
Views
402
Replies
1
Views
6K

1,196,266
Messages
6,014,333
Members
441,816
Latest member
Klingon1960

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back