| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Formating Letters to Numbers while Displaying Letters
Example formula using a helper cell.
=IF(A1="","",LOOKUP(A1,{"a","a-","b+","b","b-","c+","c","c-","d+","d","d-","f"},{4,3.7,3.3,3,2.7,2.3,2,1.7,1.3,1,0.7,0})*B1 ) entered in C1 Gord Dibben MS Excel MVP On Tue, 30 Mar 2010 18:51:57 -0700 (PDT), Luke Androsiglio wrote: I am trying to accomplish this in terms of letter grades corresponding to number grades. How do I format a cell so that I can enter a letter grade: A, A-, B+, B, etc. and the corresponding number: 4.00, 3.67, 3.33, 3.00, etc. to each letter grade will be the numeric value of the cell (which I can reference in a formula in a different cell), while the letter remains displayed in the cell? As an example: in cell A1, I would type: B+, I would like B+ to remain displayed, but the value of the cell would be 3.33. Therefore, I could multiply cell B1 (which has a value of 3.00) to cell A1 and resulting answer would be 9.99. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom number format code using letters and numbers | Excel Worksheet Functions | |||
| Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
| Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| displaying letters as average instead of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
