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 value?
If there is 10000 in cell A1, then 100 will be returned in cell B2. If there is 1000 in cell A1, then 10 will be returned in cell B2. If there is 100 in cell A1, then 1 will be returned in cell B2. If there is 10 in cell A1, then 0.1 will be returned in cell B2. If there is 1 in cell A1, then 0.01 will be returned in cell B2. Does anyone have any suggestions on how to determine the formula in cell B1? Thanks in advance for any suggestions? Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value?
hi
=if(A1=10000,100,if(A1=1000,10,if(A1=100,1,if(A1=1 0,.1,.01)))) regards FSt1 "Eric" wrote: Does anyone have any suggestions on how to determine the value? If there is 10000 in cell A1, then 100 will be returned in cell B2. If there is 1000 in cell A1, then 10 will be returned in cell B2. If there is 100 in cell A1, then 1 will be returned in cell B2. If there is 10 in cell A1, then 0.1 will be returned in cell B2. If there is 1 in cell A1, then 0.01 will be returned in cell B2. Does anyone have any suggestions on how to determine the formula in cell B1? Thanks in advance for any suggestions? Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value?
If those are the only values, you could use:
=a1/100 Eric wrote: Does anyone have any suggestions on how to determine the value? If there is 10000 in cell A1, then 100 will be returned in cell B2. If there is 1000 in cell A1, then 10 will be returned in cell B2. If there is 100 in cell A1, then 1 will be returned in cell B2. If there is 10 in cell A1, then 0.1 will be returned in cell B2. If there is 1 in cell A1, then 0.01 will be returned in cell B2. Does anyone have any suggestions on how to determine the formula in cell B1? Thanks in advance for any suggestions? Eric -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) |