top of page
How to deal with 'Inconsistent formula range'?
What does "Inconsistent formula range" mean?
The range of a formula does not fit to the logic of the other cells in the respective column or row.
Example:
In this complex formula, the last part has a range of "AB9" (highlighted in bold), shown in the "Actual" part - whereas a range of "AC9" would be expected based on the other formulas in the same row, shown in the "Expected" part.
How to fix the error:
Check if the respective cell links to a new/different section in the Excel sheet that follows a new logic. If this is not the case and you agree to the "Expected" formula, just click on "Fix" (in the example above, click on "Fix AC12")
bottom of page