Cell formula

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
 
P

PCLIVE

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
Formula Question 1
Percent and Rank formula in one cell 1
copy cells down a column (in order) to across a row (same order?? 1
How do I say… 11
I need to copy a formula to a 100 cells 3
Count only visible cells 4

Top