Filling formulas with specific cell references remaining the same

Q

quinxorin

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.
 
D

David Biddulph

A suitable topic to type into Excel help is "relative & absolute addressing"
The dollar sign in a reference makes the row, or column, absolute.
 
Q

quinxorin

Thanks. I tried all sorts of symbols, like single quotes, double quotes, and
paentheses, but I never thought to try the dollar sign.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top