With a formula in a cell, what is the warning symbol for?

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

Guest

Each time a formula references another cell, I often get a little formula
warning icon in upper left corner of cell, telling me something like, "the
formula in this cell referes to a range that has additional numbers adjacent
to it". Can you eliminate this warning?
 
From the Excel main menu:
<tools><options><error checking>
Adjust the settings to suit your preferences.
I believe the specific item you mentioned is: "Formula omits cells in region"


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
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

Formula omits adjacent cells 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Using text in a cell in a formula 2
Cell value as part of a worksheet ref. in Excel 2
What is blue symbol bottom right corner of cell 2
Spurious Formula Omits Adjacent Cells 2
Hiding the error caused by the formula in a cell / column 6
Formula - Is it possible to... 3

Back
Top