automatically converting data

B

bob Tiburzi

when i make a change in one column i would like the material t
automatically change in another column.

for example, if something cost $1.25 per pound in my unit price colum
and in my total cost column it cost $3.75; if i change my unit pric
column to 1.50 how do i automatically change the price in my tota
price column

thank you

bo
 
D

Don Guillett

in cell a3
=a1*a2
where a1 contains 2 for 2 pounds
and a2 contains 1.25 which if you change to 1.50 will change a3.
 
D

David McRitchie

Hi Bob,
A1:D2 Item, unit price, Qty, Charges
A2: Cookies, doz
B2: 1.25
C2: 3
D2: =B2*C2
 
D

DDM

Bob, the value in your Total Cost column should be the result of a formula,
not data that you've entered by hand. If your Unit Price column is, say,
Column C, your Column D might be Quantity, and Column E might be Total
Price. Say your data is entered starting with Row 2. Cell E2 should contain
the formula =C2*D2. If this is so, then should you change the value in
either C2 or D2, the result in E2 will change automatically.

For data entered in rows below Row 2, just copy the formula in E2 down to
E3, E4, etc. Excel will adjust the cell references automatically.
 
J

jeff

Hi, Bob,

You need to use a formula which calculates a new
value depending on the contents of other cells.

For example, you have $1.25 per pound in unit price
column; how did you arrive at $3.75 for total cost?
(You multiplied by 3) This is the same thing you
need to do to take advantage of Excel.

Example:
Cell A1 enter 1.25, Cell B1 enter 3,
Cell C1 enter =A1*B1

Now when you change either A1 or B1, the value of C1
reflects the product.

I hope this helps.
jeff
 
Top