ExcelBanter - Cell formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell formula (https://www.excelbanter.com/excel-discussion-misc-queries/180441-cell-formula.html)

DDR

Cell formula

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

PCLIVE

Cell formula

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

--

"DDR" wrote in message
...
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

Gary''s Student

Cell formula

=INDIRECT("C10")
--
Gary''s Student - gsnu200774

JohnH

Cell formula

=C9=INDIRECT("C10")

"DDR" wrote:

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

All times are GMT +1. The time now is 04:54 PM.