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.

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.

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.


.