Forum Discussion
Inconsistent Formula
I need help trying to figure out why adding or deleting a row, or dragging and dropping data to create a row is causing Inconsistent Formulas in one column. For example, the excel spreadsheet is not ...
Why do the formulas in column K subtract column I from fixed numbers such as 1275.75 and 901.2?
- This spreadsheet tracks accumulated hours on engines. Each row refers to a specific engine, that has a specific driver that causes the engine to be removed.
I'm afraid I don't understand, sorry.
- Each row factors different hours for different engines. The formulas in column K used fixed hours and the formulas from column I. The issue is that adding a row caused the formulas in column K to offset by one row.
