 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Second Posting for Extending Formula
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??? Have a look at: http://office.microsoft.com/en-us/excel/HP052291251033.aspx  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Sorry if this question stumped the experts. Or maybe no one saw the > question. I'll try posting it again. [quoted text clipped - 22 lines] > > Can someone tell me what I'm missing??? 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? > Have a look at: > [quoted text clipped - 28 lines] >> >> Can someone tell me what I'm missing??? Sorry, I don't have XL2003 to test it for you. SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > 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 [quoted text clipped - 34 lines] >>> >>> Can someone tell me what I'm missing??? Does the formula I'm having trouble with work in Excel 2007?? > Sorry, I don't have XL2003 to test it for you. > [quoted text clipped - 37 lines] >>>> >>>> Can someone tell me what I'm missing??? Your going the wrong way - I have XL97 which does not have the Extend formulas option at all. SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Does the formula I'm having trouble with work in Excel 2007?? > [quoted text clipped - 39 lines] >>>>> >>>>> Can someone tell me what I'm missing??? 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 > Does the formula I'm having trouble with work in Excel 2007?? > [quoted text clipped - 28 lines] >>>>> >>>>> Can someone tell me what I'm missing??? 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. > BK, > [quoted text clipped - 49 lines] >>>>>> >>>>>> Can someone tell me what I'm missing??? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.