software

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 quot;=(B2*30%)-(A3*12)quot;
The resulting in correct formula after the drag and copy is quot;=(C2*30%)-(B3*12)quot;
The B3 reference should always point to the A col so as with the reference above the correct formula would be quot;=(C2*30%)-(A3*12)quot;

Thanks in advance. - CES


hi!
make your original formula as

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

-via135

CES Wrote:
gt; All,
gt; I'm sure that this is easily found but I'm not sure what to search
gt; for.
gt;
gt; I have a formula that i want to persist throughout the worksheet. The
gt; figures I want to always have calculated are in a header row in this
gt; case row 2:
gt;
gt; 1000 - 2000 - 3000 - etc.
gt;
gt; I also have a column that provides the other number to be calculated in
gt; this case column A:
gt;
gt; 50
gt; 100
gt; 150
gt; etc.
gt;
gt; However when I drag and copy the correct formula from one cell to the
gt; next the cell reference dos not change properly
gt; The Original correct formula is quot;=(B2*30%)-(A3*12)quot;
gt; The resulting in correct formula after the drag and copy is
gt; quot;=(C2*30%)-(B3*12)quot;
gt; The B3 reference should always point to the A col so as with the
gt; reference above the correct formula would be quot;=(C2*30%)-(A3*12)quot;
gt;
gt; Thanks in advance. - CES--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=523213In 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.

quot;CESquot; wrote:

gt; All,
gt; I'm sure that this is easily found but I'm not sure what to search for.
gt;
gt; 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:
gt;
gt; 1000 - 2000 - 3000 - etc.
gt;
gt; I also have a column that provides the other number to be calculated in this case column A:
gt;
gt; 50
gt; 100
gt; 150
gt; etc.
gt;
gt; However when I drag and copy the correct formula from one cell to the next the cell reference dos not change properly
gt; The Original correct formula is quot;=(B2*30%)-(A3*12)quot;
gt; The resulting in correct formula after the drag and copy is quot;=(C2*30%)-(B3*12)quot;
gt; The B3 reference should always point to the A col so as with the reference above the correct formula would be quot;=(C2*30%)-(A3*12)quot;
gt;
gt; Thanks in advance. - CES
gt;

Change the original formula from:

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

Then your drag copies will leave A3 alone.
--
Gary's Studentquot;CESquot; wrote:

gt; All,
gt; I'm sure that this is easily found but I'm not sure what to search for.
gt;
gt; 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:
gt;
gt; 1000 - 2000 - 3000 - etc.
gt;
gt; I also have a column that provides the other number to be calculated in this case column A:
gt;
gt; 50
gt; 100
gt; 150
gt; etc.
gt;
gt; However when I drag and copy the correct formula from one cell to the next the cell reference dos not change properly
gt; The Original correct formula is quot;=(B2*30%)-(A3*12)quot;
gt; The resulting in correct formula after the drag and copy is quot;=(C2*30%)-(B3*12)quot;
gt; The B3 reference should always point to the A col so as with the reference above the correct formula would be quot;=(C2*30%)-(A3*12)quot;
gt;
gt; Thanks in advance. - CES
gt;