LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pre determine value Malik Nadeem Excel Discussion (Misc queries) 4 September 20th 07 06:30 AM
How to determine the value? Eric Excel Discussion (Misc queries) 7 August 16th 07 01:42 AM
How to determine the value? Eric Excel Discussion (Misc queries) 1 July 24th 07 07:14 AM
How to determine the value? Eric Excel Discussion (Misc queries) 1 February 13th 07 04:20 AM
How to determine the value? Eric Excel Discussion (Misc queries) 0 February 13th 07 03:26 AM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"