| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling formulas with specific cell references remaining the same
I need to fill a formula in a range of cells downward, specifically the
formula IF(OR(O2=U1,P2=U1,Q2=U1),2-L2,0), with the U1 cell references remaining the same, continuing to refer to U1, while the other cell references (O2, P2, Q2, and L2) change and fill normally. Conversely, I need to be able to fill the formula right with U2 being the only reference that changes. Is this possible to do? If so, how? Doing this manually would take several hours. I am using Excel 2007. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filling formulas with specific cell references remaining the same
A suitable topic to type into Excel help is "relative & absolute addressing"
The dollar sign in a reference makes the row, or column, absolute. -- David Biddulph "quinxorin" wrote in message ... I need to fill a formula in a range of cells downward, specifically the formula IF(OR(O2=U1,P2=U1,Q2=U1),2-L2,0), with the U1 cell references remaining the same, continuing to refer to U1, while the other cell references (O2, P2, Q2, and L2) change and fill normally. Conversely, I need to be able to fill the formula right with U2 being the only reference that changes. Is this possible to do? If so, how? Doing this manually would take several hours. I am using Excel 2007. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filling formulas with specific cell references remaining the s
Thanks. I tried all sorts of symbols, like single quotes, double quotes, and
paentheses, but I never thought to try the dollar sign. "David Biddulph" wrote: A suitable topic to type into Excel help is "relative & absolute addressing" The dollar sign in a reference makes the row, or column, absolute. -- David Biddulph "quinxorin" wrote in message ... I need to fill a formula in a range of cells downward, specifically the formula IF(OR(O2=U1,P2=U1,Q2=U1),2-L2,0), with the U1 cell references remaining the same, continuing to refer to U1, while the other cell references (O2, P2, Q2, and L2) change and fill normally. Conversely, I need to be able to fill the formula right with U2 being the only reference that changes. Is this possible to do? If so, how? Doing this manually would take several hours. I am using Excel 2007. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell references in formulas | Excel Discussion (Misc queries) | |||
| Filling in worksheet cell references | Excel Discussion (Misc queries) | |||
| count specific weedays remaining in quarter | Excel Worksheet Functions | |||
| How do I set up a Custom Header that references a specific cell | Excel Discussion (Misc queries) | |||
| How do I change column references when filling down a formula | Excel Discussion (Misc queries) | |||
Linear Mode
