Cell formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DDR - 18 Mar 2008 15:57 GMT

I have a simple formula C9 = C10. When I insert a new row which makes C10 C11
I want the formula to still look at C10. Currently when I add a new row the
formula changes. Any help is appreciated

Reply to this Message

PCLIVE - 18 Mar 2008 16:08 GMT

Probably another way, but as long as you don't plan on copying this formula
to other locations expecting it to automatically change, then you could use
this.

=INDIRECT("C9")=INDIRECT("C10")

HTH,
Paul

>I have a simple formula C9 = C10. When I insert a new row which makes C10
>C11
> I want the formula to still look at C10. Currently when I add a new row
> the
> formula changes. Any help is appreciated

Reply to this Message

Gary''s Student - 18 Mar 2008 16:11 GMT

=INDIRECT("C10")

Signature

Gary''s Student - gsnu200774

Reply to this Message

JohnH - 18 Mar 2008 16:13 GMT

=C9=INDIRECT("C10")

> I have a simple formula C9 = C10. When I insert a new row which makes C10 C11
> I want the formula to still look at C10. Currently when I add a new row the
> formula changes. Any help is appreciated

Reply to this Message