What does inconsistent formula mean in excel

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Why my formula is showing error - Inconsistent calculated column formula in MS Excel? Ask Question. Asked 4 years ago. Active 2 years, 8 months ago. Viewed 12k times. Please help. Improve this question. Amlan Dutta Amlan Dutta 2 2 gold badges 4 4 silver badges 16 16 bronze badges. Doesn't this just mean that this formula is different from other formulas in the same column?

I wouldn't worry about it - you're probably not missing anything! Excel tosses up that flag when what seems to Excel ought to be similar formulas in adjacent cells, but they are just slightly different - usually by your design. It's an 'alert', not a critical alarm.

Was this reply helpful? Yes No. To ignore error indicators for multiple cells at a time, select the range that contains the errors that you want to ignore. Next, click the arrow next to the button that appeared , and on the shortcut menu, select Ignore Error. To ignore error indicators for a whole sheet, first click a cell that has an error indicator.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Detect errors in formulas. Hide error values and error indicators.

Doing that lets you see the formulas in all cells, instead of the calculated results. Then select the cell that does have the problem. More solutions. Select the cell with the problem. Click OK or Next to jump to the next error. Click the arrow next to the button that appears. The shortcut menu shows the options that are available to resolve this warning. Do any of the following: Select To Copy Formula from Above Make the formula consistent by copying the pattern from the cell above.

Ignore Error Remove the error indicator, for example, if the inconsistency in the formula is intentional or otherwise acceptable. However in some instances you may have built a formula down a column of cells e. Both instances require you to select the cell that you would like to test, highlight the cells that you would like to check for consistency, and perform the desired shortcut.