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