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 ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jul 23, 2024

TimurS1976 

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

TimurS1976's avatar
TimurS1976
Copper Contributor
Jul 23, 2024
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.
    • TimurS1976's avatar
      TimurS1976
      Copper Contributor
      Jul 23, 2024
      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.
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jul 23, 2024

        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.

Resources