Inconsistent Formula

[TimurS1976]

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.

[#2]

@TimurS1976 

Why do the formulas in column K subtract column I from fixed numbers such as 1275.75 and 901.2?

[#3]

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.

[#4]

@TimurS1976 

I'm afraid I don't understand, sorry.

[#5]

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.

[#6]

@TimurS1976

If I have a formula in J15

=1000-I15

and then insert cells in or above those cells, the formula is now in J16 and reads

=1000-I16

The only way the formula would remain

=1000-I15

would be if I pushed J15 down but not I15. So I don't see how you got to the situation you show.

[#7]

That's why I'm requesting assistance. I know that if I only added or removed a single cell, then things would shift. I inserted a complete row, and for some reason it caused those cell formulas to misalign, all the way down the spreadsheet.

[#8]

@TimurS1976 

I cannot reproduce or explain that...

[#9]

Thanks

[#10]

Result: there were cells that had Conditional Formatting rules set. Once those were removed, i was able to Insert/Delete rows without the above or below formulas being affected/shifting/misaligning.