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

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

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