Imagine 3 columns. Cell A1 reads the quantity, Cell B1 reads the Cost and cell C1 reads the Total. Cell A2 has a number 1 in it. Cell B2 has $10.00 in it and Cell C2 should then have $10.00 in it. If I change Cell A2 (the quantity) to 8, then Cell C2 should change to $80.00. Conversely if have Cell A2 be 1, Cell B2 to read $20.00 Cell C2 should be $20.00.



A B C
1 1 $10 10

A B C
1 2 $10 20

A B C
1 8 $15 120

I hope this clears it up.

Hi again,
I am still i little unsure if I got you completely. See the attached file, with some very simple formulas. At what situation does this not work for you?
Will you (manually) only change the values in cell A2 and B2?

Kind regards
Bjorn

Attached Files

Qty_Cost_Total.xls (13.5 KB, 33 views)