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

hi!
make your original formula as

=(B2*30%)-($A$3*12)

-via135




CES Wrote:
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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=523213

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.

"CES" wrote:

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

Change the original formula from:

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

Then your drag copies will leave A3 alone.
--
Gary's Student


"CES" wrote:

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