How to determine the value?
 

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

How to determine the value?
 

Put this in B1:

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

and copy down as required.

Hope this helps.

Pete

On Mar 7, 12:39*am, Eric wrote:
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

How to determine the value?
 

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

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

Hope this helps.

Pete

On Mar 7, 12:52*am, Pete_UK wrote:
Put this in B1:

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

and copy down as required.

Hope this helps.

Pete

On Mar 7, 12:39*am, Eric wrote:



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 -