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:
Next, use the VLOOKUP function to convert the number to the letter grade:
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.