How to determine the value?

E

Eric

Does anyone have any suggestions on how to determine the value?
There is an input value under A column.
Under B column, there is a factor to be calculated based on the value under
A column. I would like to return the value under C column, which is always
in 3-digiti format by A1 * B1 = C1 in 3 - digit format
Please see following examples:

1000 [A1] 0.1 [B1] 100 [C1]
3654 [A2] 0.1 [B2] 365.4 [C2]
23654 [A3] 0.01 [B3] 236.54 [C3]
600.5 [A4] 1 [B4] 600.5 [C4]
80.6 [A5] 10 [B5] 806 [C5]
7.35 [A6] 100 [B6] 735 [C6]
0.837 [A7] 1000 [B7] 837 [C7]
0.054 [A8] 10000 [B8] 540 [C7]

Does anyone have any suggestions on how to determine the formula for B column?
Thanks in advance for any suggestions
Eric
 
P

Pete_UK

Put this in B1:

=10^(2-INT(LOG10(A10)))

and copy down as required.

Hope this helps.

Pete
 
P

Pete_UK

Sorry, the reference should have been to A1, not A10:

=10^(2-INT(LOG10(A1)))

Hope this helps.

Pete

Put this in B1:

=10^(2-INT(LOG10(A10)))

and copy down as required.

Hope this helps.

Pete

Does anyone have any suggestions on how to determine the value?
There is an input value under A column.
Under B column, there is a factor to be calculated based on the value under
A column. I would like to return the value under C column, which is always  
in 3-digiti format by A1 * B1 = C1 in 3 - digit format
Please see following examples:
1000 [A1] 0.1 [B1] 100 [C1]
3654 [A2] 0.1 [B2] 365.4 [C2]
23654 [A3] 0.01 [B3] 236.54 [C3]
600.5 [A4] 1 [B4] 600.5 [C4]
80.6 [A5] 10 [B5] 806 [C5]
7.35 [A6] 100 [B6] 735 [C6]
0.837 [A7] 1000 [B7] 837 [C7]
0.054 [A8] 10000 [B8] 540 [C7]
Does anyone have any suggestions on how to determine the formula for B column?
Thanks in advance for any suggestions
Eric- Hide quoted text -

- Show quoted text -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top