How can I set number values for letters (eg. B, A-) in Excel 2003

L

Lawrence500

How can I set hidden number values for letter inputs such as B+, B, B-, and
have a final calulation, such as an average, displayed as a number in Excel
2003?
 
A

Ardus Petus

Create a lookup table with A+ A A- B+ B B- in a column.
In adjacent column, enter values for each of these grades

To translate grade into value, use VLOOKUP:
=VLOOKUP("A+",lookup_table,2,false)

HTH
 
Top