Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is inconsistent formula in region in excel?
Please advise what causes inconsistent formula in region in Excel?
How to resolve when it occurs? Or to prevent it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is inconsistent formula in region in excel?
That means formulas in cells in the same region of the sheet are different.
It's just Excel trying to be helpful. For example: A1 formula: =SUM(B1:J1) A2 formula: =SQRT(Y100) You can probably ignore that message. To turn off those messages goto the menu ToolsOptionsError Checking tabRules. Uncheck the items you don't want to see messages for. I have all of the error checking rule settings turned off. -- Biff Microsoft Excel MVP "Eric" wrote in message ... Please advise what causes inconsistent formula in region in Excel? How to resolve when it occurs? Or to prevent it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA | Excel Discussion (Misc queries) | |||
Inconsistent Formula? | Excel Discussion (Misc queries) | |||
Formula results inconsistent. | Excel Worksheet Functions | |||
Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) | |||
Cell just shows formula after named region var change | Excel Worksheet Functions |