| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
With a formula in a cell, what is the warning symbol for?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
With a formula in a cell, what is the warning symbol for?
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 "brobcpa" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what symbol should i put in the formula to make a cell constant? | Excel Discussion (Misc queries) | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
| Can I Delete Symbol in Cell That Has A Formula? | Excel Discussion (Misc queries) | |||
| how do I display "meter square" symbol in a formula cell ? | Excel Worksheet Functions | |||
Linear Mode
