Forum Discussion
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 precedents and format of my cells and they are correct. Has anyone experienced this?
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.
