| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value?
=10^(2-INT(LOG10(A2)))
-- David Biddulph "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value?
Try the formula:
=(A1/(POWER(10,(LEN(INT(A1))-3))))/A1 -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value?
Actually it should be:
=1/(POWER(10,(LEN(INT(A1))-3))) -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Satti Charvak" wrote: Try the formula: =(A1/(POWER(10,(LEN(INT(A1))-3))))/A1 -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
