Cell formula

  • Thread starter Thread starter DDR
  • Start date Start date
D

DDR

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

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

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Subtotal 3
Count only visible cells 4
I need to copy a formula to a 100 cells 3
Percent and Rank formula in one cell 1
Formula Question 1
copy cells down a column (in order) to across a row (same order?? 1
Macro Relative Cells 3

Back
Top