How to determine the value?

[Eric]

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

 

[FSt1]

hi
=if(A1=10000,100,if(A1=1000,10,if(A1=100,1,if(A1=10,.1,.01))))

regards
FSt1

 

[Dave Peterson]

If those are the only values, you could use:

=a1/100