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 allowing me to Rt Click - Insert or Delete a row. I then select all data between B2 and M50, then I drag and drop all of those cells down one row, to create an empty row of data. Reason being, to add 632 before 637 at B1. When I do this, the data in Column K creates an Inconsistent Formula.
Notice in the screenshot below where the formulas beginning on Row 16 at K16, it begins to repeat the above formula (I15). It should read "=901.2-I16" as opposed to "=901.2-I15"
Please advise.
Why do the formulas in column K subtract column I from fixed numbers such as 1275.75 and 901.2?
- TimurS1976Copper ContributorThis 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.