Stopping Excel from editing my Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get excel to stop automatically editing my formulas when I
delete cells. Like right now I have a two lists of data and I'm going through
to find the same data points between the lists. So I have on list in column B
and one in column C. So my formula in column D is =if(B1=C1, "TRUE") but
every time I go to delete cells from column C and move them to the top my
formula changes to =if(B1=!REF, "True") and if I deleted say one cell the
next line row in column D the formula will be =if(B2=C1, "TRUE") How Can I
stop Excel from doing this?
 
Wrap each cell reference in INDIRECT

=INDIRECT("A2")

will not return an error
 
You must log in or register to reply here.

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

Show other cell if blank 5
Data Validation and drop-down list using IF, AND and what else? 8
Excel VBA 1
Cell colour change if formula displays false 3
Very strange behaviour of VLOOKUP in Excel 2010 4
Need Help with a Formula 4
Formula wanted 5
Help needed 0

Back
Top