Dragging formulas to new cells

[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.

 

[Ragdyer]

Try this:

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

 

[Sandy Mann]

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.

 

[Stan Brown]

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.

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.

 

[Greg Maxey]

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.

 

[Harlan Grove]

Please don't post in MIMEd HTML. Post in plain text.

 

[Greg Maxey]

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?

 

[Harlan Grove]

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?

....

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.