| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems copying a formula between worksheets | Excel Discussion (Misc queries) | |||
| Maintaining Formula after adding a new row | New Users to Excel | |||
| Adding the contents of a cell to a formula | Excel Discussion (Misc queries) | |||
| Adding a formula within a formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
