View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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