If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a constant to a formula. Problems w/filling in
I am trying to find a way to "fill in" a funtion. I have F2=E2+F1, for example. I want the cell next to it, G2, to be =E2+G1. In other words, I want Row 2 to be the addition of E2 to each cell in Row 1. however, when i "fill in", G2 becomes =F2+G1. How do I make E2 a constant in the formula? -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=507968 |
#2
|
|||
|
|||
Adding a constant to a formula. Problems w/filling in
Just fix the column ref ("E") in "E2" with a dollar sign ($)
Amend the formula in F2 to: =$E2+F1 Then copy F2 to G2 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "zuri125" wrote in message ... I am trying to find a way to "fill in" a funtion. I have F2=E2+F1, for example. I want the cell next to it, G2, to be =E2+G1. In other words, I want Row 2 to be the addition of E2 to each cell in Row 1. however, when i "fill in", G2 becomes =F2+G1. How do I make E2 a constant in the formula? -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=507968 |
#3
|
|||
|
|||
Adding a constant to a formula. Problems w/filling in
Hi!
Use this as the formula in F2: =$E2+F1 Then just copy across the row as needed. The $ keeps the column from changing. Biff "zuri125" wrote in message ... I am trying to find a way to "fill in" a funtion. I have F2=E2+F1, for example. I want the cell next to it, G2, to be =E2+G1. In other words, I want Row 2 to be the addition of E2 to each cell in Row 1. however, when i "fill in", G2 becomes =F2+G1. How do I make E2 a constant in the formula? -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=507968 |
#4
|
|||
|
|||
Adding a constant to a formula. Problems w/filling in
ok, thanks you for that. But, the $ only works for rows. I have F2=E2+F1, for example. I want the cell below it, F3, to be =E3+F1. In other words, I want Column F to be the addition of F1 to each cell in Column E. however, when i "fill in", F3 becomes =E3+F2. How do I make F1 a constant in the formula? -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=507968 |
#5
|
|||
|
|||
Adding a constant to a formula. Problems w/filling in
Use this:
=$E2+F$1 Biff "zuri125" wrote in message ... ok, thanks you for that. But, the $ only works for rows. I have F2=E2+F1, for example. I want the cell below it, F3, to be =E3+F1. In other words, I want Column F to be the addition of F1 to each cell in Column E. however, when i "fill in", F3 becomes =E3+F2. How do I make F1 a constant in the formula? -- zuri125 ------------------------------------------------------------------------ zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131 View this thread: http://www.excelforum.com/showthread...hreadid=507968 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding the contents of a cell to a formula | Paul Bond | General Discussion | 1 | January 21st, 2006 07:19 PM |
VBA Animation Effects - which are entrance, exit, etc | John Michl | Powerpoint | 4 | January 11th, 2006 02:44 PM |
Sum formula is not adding up properly | Michelle | General Discussion | 4 | November 4th, 2005 11:18 AM |
Formula Constant | dale1948 | Worksheet Functions | 2 | November 2nd, 2005 09:44 PM |
help adding to my formula | Worksheet Functions | 5 | August 4th, 2004 07:15 AM |