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
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.

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

Resources