| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Transformation
By entering a numerical value in a cell A1, I would like to see another value
displayed in cell B1. For instance, a 1 in A1 would display 11 in B1. 1 = 11 2 = 8 3 = 7 Else = 0 set below. 4 = 0 5 = 0 6 = 0 7 = 0 8 = 0 9 = 0 0 = 0 Might this be possible with ISERROR? -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Test Scores to somewhat of a Linear Transformation | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
