 |
 | 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 / February 2008Copying a formula
How would I do this? I want C1 to contain the result of B1-A1 And then I want C2 to contain the result of B2-A2. and so on.... I want the resulting difference to be in column C, for each row. How can I copy the formula from C1 to each cell below it, with the formula in each subsequent cell referring to the cells in that row, not row1? A B C ---------------------------------------------- 1 | | | B1-A1 ----------------------------------------------- 2 | | | B2-A2 ----------------------------------------------- 3 | | | B3-A3 Simply put the formula in C1: =B1-A1 and press enter. Then select C1, put your cursor on the lower right hand corner of C1 where the black box (the fill handle) is, your cursor will change to a black cross, click on that and drag your formula down column C as far as you want. Excel will adjust the addresses in the formula automatically Tyro. > How would I do this? > I want C1 to contain the result of B1-A1 [quoted text clipped - 10 lines] > ----------------------------------------------- > 3 | | | B3-A3 Ok, now I feel stupid. I had tried that. But it didn't work. And I just now realized that it didn't work because I had a heading in line 1, and my data didn't start until line 4! Thanks. > Simply put the formula in C1: =B1-A1 and press enter. Then select C1, put > your cursor on the lower right hand corner of C1 where the black box (the [quoted text clipped - 19 lines] >> ----------------------------------------------- >> 3 | | | B3-A3 Just grab the fill handle of C1 by left-click and drag/copy down column C. The cell refs will increment as you go. If the results shown are the same, perhaps go to Tools>Options>Caculation and checkmark "Automatic" Gord Dibben MS Excel MVP >How would I do this? >I want C1 to contain the result of B1-A1 [quoted text clipped - 10 lines] >----------------------------------------------- >3 | | | B3-A3 |
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.