| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Substituting letters for numers
I am trying to substitute letters for number values.
Trying to calculate my GPA while substituting an A for 4.0, (A=4.0) and B=3.0 ... I want to be able to see the letter grade in the sheet but be able to multiply by the umber of credit hours. Like A*4cc=16 The A would equal 4 and 4*4=16 any help would be greatly appreciated. thanks mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format to to automatically get page of consecutive numers 1 2 3 | Excel Worksheet Functions | |||
| Giving numers value to selections | Excel Discussion (Misc queries) | |||
| Replacing or Substituting Text | Excel Worksheet Functions | |||
| excel is substituting unicode for a defined name of a cell | Excel Discussion (Misc queries) | |||
| substituting two text occurances in same cell. | Excel Worksheet Functions | |||
Threaded Mode
