Changing a cell referance on multipule cells

C

CES

All,
I'm sure that this is easily found but I'm not sure what to search for.

I have a formula that i want to persist throughout the worksheet. The figures I want to always have calculated are in a header row in this case row 2:

1000 - 2000 - 3000 - etc.

I also have a column that provides the other number to be calculated in this case column A:

50
100
150
etc.

However when I drag and copy the correct formula from one cell to the next the cell reference dos not change properly
The Original correct formula is "=(B2*30%)-(A3*12)"
The resulting in correct formula after the drag and copy is "=(C2*30%)-(B3*12)"
The B3 reference should always point to the A col so as with the reference above the correct formula would be "=(C2*30%)-(A3*12)"

Thanks in advance. - CES
 
S

Superchikn

In the formula...put a $ in front of the A that will lock the formula to the
A column coumn but will leave the row floating. To lock to A2 make the
formula $A$2.

Hope this makes sense.
 
G

Gary''s Student

Change the original formula from:

=(B2*30%)-(A3*12)
to
=(B2*30%)-($A3*12)

Then your drag copies will leave A3 alone.
 
Top