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