Monday, July 12, 2010

How do you assign a letter grade to a number in an Excel spreadsheet?

A frequently asked question is how do you assign a letter grade to a numeric value.  This is actually very simple.  First, you need to create a defined name called "Grades" which refers to the array:

={0,"F";60,"D";70,"C";80,"B";90,"A"}


Next, use the VLOOKUP function to convert the number to the letter grade:

=VLOOKUP(A1,Grades,2)


In this case, A1 is the cell that contains the numeric value.  You can add entries to the Grades array for other grades like C- and C+, just make sure the numeric values in the array are in increasing order.


Also, I am currently planning for my honeymoon so what I have turned to in order to keep my notes and thoughts organized? Excel spreadsheets of course! So stay tuned for my Honeymoon/vacation planning/budgeting Excel spreadsheet.