Formula automatically changing cell references

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

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

"Nina" <[email protected]> wrote in message
news:[email protected]...
> Hi, Hope you (someone) can help. I have a large spreadsheet on which I
> want
> to use the following formula:
> =OR(AND(INDIRECT(,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.
> --
> Nina