Formula automatically changing cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Hope you (someone) can help. I have a large spreadsheet on which I want
to use the following formula:
=OR(AND(D17>H11,F17>H13),H12-(D17-H11+E17))*(AND(D17<H11,F17<H13))*(H12-E17).
All the cell references change when I copy the formula into a new cell. The
problem is that I need H11, H12, and H13 need to stay no matter where on the
spreadsheet I copy the formula. How can I make only part of the formula hold
and the rest change? Thanks for any help you can give.
 
Hi!

You'd have to wrap those particular cell references inside an Indirect
function:

INDIRECT("H11")

Then, no matter where you copy the formula, INDIRECT("H11") will always
reference back to H11.

Biff
 
Back
Top