Forum Discussion

TimurS1976's avatar
TimurS1976
Copper Contributor
Jul 23, 2024

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.

    • TimurS1976's avatar
      TimurS1976
      Copper Contributor
      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.

Resources