Dragging formulas to new cells

  • Thread starter Thread starter Greg Maxey
  • Start date Start date
G

Greg Maxey

I have the following formula in cell B2:

=(A2 *(2-B1)/1000)*T2+S2

When I drag this formula to Cell C2 I would like for it to appear like:

=(A2 *(2-C1)/1000)*T2+S2

and dragged to D2, etc appear like:

=(A2 *(2-D1)/1000)*T2+S2

where only the value B1 is changed to C1 then C1 change to D1 while and A2,
T2, and S2 stay the same each time.

Right now A2, T2, and S2 also increment by 1 when I drag the formula. Is
there some way to lock these values so they don't increment? Thanks.
 
Make all the cell references except the B1 one absolute:

=($A$2 *(2-B1)/1000)*$T$2+$S$2

(Nice pretty formatting in your post but the regulars in these NG's prefer
that people post in Plain Text)
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


I have the following formula in cell B2:

=(A2 *(2-B1)/1000)*T2+S2

When I drag this formula to Cell C2 I would like for it to appear like:

=(A2 *(2-C1)/1000)*T2+S2

and dragged to D2, etc appear like:

=(A2 *(2-D1)/1000)*T2+S2

where only the value B1 is changed to C1 then C1 change to D1 while and A2,
T2, and S2 stay the same each time.

Right now A2, T2, and S2 also increment by 1 when I drag the formula. Is
there some way to lock these values so they don't increment? Thanks.
 
Sun, 29 Jul 2007 14:23:57 -0400 from Greg Maxey
I have the following formula in cell B2:

=(A2 *(2-B1)/1000)*T2+S2

When I drag this formula to Cell C2 I would like for it to appear like:

=(A2 *(2-C1)/1000)*T2+S2

and dragged to D2, etc appear like:

=(A2 *(2-D1)/1000)*T2+S2

where only the value B1 is changed to C1 then C1 change to D1 while and A2,
T2, and S2 stay the same each time.

Right now A2, T2, and S2 also increment by 1 when I drag the formula. Is
there some way to lock these values so they don't increment? Thanks.
Click to expand...

There is indeed. Look up "absolute and relative references" in Help.

The short answer is: put a $ before any element you don't want to
change. The help will explain the differences among A2, A$2, $A2, and
$A$2.
 
Thanks everyone. That works perfectly.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

I have the following formula in cell B2:

=(A2 *(2-B1)/1000)*T2+S2

When I drag this formula to Cell C2 I would like for it to appear like:

=(A2 *(2-C1)/1000)*T2+S2

and dragged to D2, etc appear like:

=(A2 *(2-D1)/1000)*T2+S2

where only the value B1 is changed to C1 then C1 change to D1 while and
A2, T2, and S2 stay the same each time.

Right now A2, T2, and S2 also increment by 1 when I drag the formula. Is
there some way to lock these values so they don't increment? Thanks.
 
Ok, but you will need to educate me. I had no idea that I am posting in a
format frowned upon. How to I do it the way you asked?
 
Greg Maxey said:
Ok, but you will need to educate me. I had no idea that I am posting in
a format frowned upon. How to I do it the way you asked?
Click to expand...
....

Headers from your previous message:

MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0013_01C7D1F6.19686320"
....
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
....
This is a multi-part message in MIME format.

------=_NextPart_000_0013_01C7D1F6.19686320
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


This last message of yours to which this is a response doesn't contain these
headers and is in plain text.

I suppose if you sent your earlier message as e-mail as well as a newsgroup
posting, Outlook Express may have used your e-mail settings rather than your
newsgroup settings.
 
Back
Top