| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| translate number in dollars to wording in excel 2003 | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How do I automatically assign an invoice number in Excel 2003 (I . | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
