| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value?
Does anyone have any suggestions on how to determine the values?
I would like to multiple value, and make any number to be 3 digits numbers. For example, there is 12345 in cell A1, it will become 123.45 by multiple 0.01, then 0.01 will be returned in cell B1. For example, there is 123 in cell A1, it will become 123 by multiple 1, then 1 will be returned in cell B1. For example, there is 1.2345 in cell A1, it will become 123.45 by multiple 100, then 100 will be returned in cell B1. Does anyone have any suggestions on how to do it in Excel? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the max. value? | Excel Worksheet Functions | |||
| How to determine the max. value? | Excel Worksheet Functions | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
Threaded Mode
