Excel Formula for changing value

[Nandan]

Hi
I have worksheet like

Column A Column B
Item Name Qty
METHYL HEPTENONE 250
METHYL CHLORO 297
DIMETHYL 10
SODIUM 150

If i enter 250 color red according to that below value change if i enter 350 instead of 250 output will be 416 in place of 297, 14 in place of 10, and 210 in place of 150. formula is (297*350)/250. but if change 250 to 350 my previous value is gone i cannot calculate for that i have 2 calculate in on column D. but i want calculation is same column i.e column B. Can anybody provide me suggestion or formula for this problem

Regards

Nandan

 

[Joe4]

Let's say that thise values are in cells B2:B5.
I would leave them there so you have your ratios to work from.
Then, you can enter 350 in C2, and enter the following forumula in C3 and copy down to C4 and C5:

=ROUND(B3*C$2/B$2,0)

 

[Nandan]

Thanks it work Joe4!!!

If u want i can mail u Excel sheet so u can understand all.

In Output column i want formula


Regards

Nandan

 

[Joe4]

I am confused.
Are you saying it worked out, or it didn't?

 

[Nandan]

yeah it is working but how to do it

if i have 500 row thats what i m asking

Thanks & Regards

Nandan

 

[Joe4]

After you get the first formula in (and working correctly), just copy it down 500 rows.