Forum Discussion
Formula Inconsistency
- Aug 09, 2024
Paula1784 What exactly does the error message say? I suspect that you have 'error checking' enabled. Then, Excel can alert you when you have used a formula that is inconsistent with adjacent formulas. So, that's not an error. Just an alert. As long as you are convinced that the formula is correct you may ignore the 'error' alert. Personally, I find this one of the most disturbing 'features' in Excel and have switched it off.
Paula1784 What exactly does the error message say? I suspect that you have 'error checking' enabled. Then, Excel can alert you when you have used a formula that is inconsistent with adjacent formulas. So, that's not an error. Just an alert. As long as you are convinced that the formula is correct you may ignore the 'error' alert. Personally, I find this one of the most disturbing 'features' in Excel and have switched it off.