Second Posting for Extending Formula

[BK]

Sorry if this question stumped the experts. Or maybe no one saw the
question. I'll try posting it again.

Using Excel 2003 and am having trouble getting a formula to extend to
new rows. I ran a trial formula that simply adds the number in A1 to the
number in B1 and puts the result in C1. I copied that formula down five
rows and filled data into Column A and Column B. When I added new rows, the
formula extended into the new rows just perfectly. Results appeared in
Column C.

Then I ran a different trial formula. I entered a number into C1 (100) and
I put
a number in A2 (10) and a number in B2 (5). The formula I built in C3 was
to start
with the number in C1, add the number in A2 and subtract the number in B2.
The formula works just fine in C3 and works just fine when I copy it down
five
rows and fill data into Column A and Column B.

What does NOT happen is that when I add a new row of data with a number in
Column A and a number in Column B, the formula does not automatically extend
to produce a new result in Column C.

Can someone tell me what I'm missing???

 

[Sandy Mann]

Have a look at:

http://office.microsoft.com/en-us/excel/HP052291251033.aspx

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

 

[BK]

Yes, I know about that. My formula IS in the preceding five rows. The
automatic extending into new rows works with one kind of formula but not
with the second formula that I explained below. Can you try it and see
what you think?

 

[Sandy Mann]

Sorry, I don't have XL2003 to test it for you.

--

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

 

[BK]

Does the formula I'm having trouble with work in Excel 2007??

 

[Sandy Mann]

Your going the wrong way - I have XL97 which does not have the Extend
formulas option at all.

--

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

 

[Bernie Deitrick]

BK,

I can confirm that the behavior you describe does occur, and that is seems that one unstated
requirement for the formula extension is that all cell referred to in the formula must be on the
same row as the formula.

HTH,
Bernie
MS Excel MVP

 

[BK]

Thank you so much for your input. At least I know that I'm not crazy. I
guess I'll go back to the drawing board and see if there is any way to
rewrite the formula. Or maybe I'll just manually copy the formula down to
each new row of data that I add.