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

[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?

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

"Lawrence500" <Lawrence500@discussions.microsoft.com> a écrit dans le
message de news: 4F07E9EB-FB28-4211-B9B6-CB836218BCA3@microsoft.com...
> 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?