Forum Discussion
Paula1784
Aug 09, 2024Copper Contributor
Formula Inconsistency
I am getting an error with a formula being inconsistent. I have double checked the formula with any and all formulas and there are no inconsistencies. I have verified my formula through the preceden...
- 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.
Riny_van_Eekelen
Aug 09, 2024Platinum Contributor
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.