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