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

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?

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

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
--
AP

"Lawrence500" a écrit dans le
message de news: ...
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?