Forum Discussion
TimurS1976
Jul 23, 2024Copper Contributor
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 ...
HansVogelaar
Jul 23, 2024MVP
Why do the formulas in column K subtract column I from fixed numbers such as 1275.75 and 901.2?
TimurS1976
Jul 23, 2024Copper 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.
- HansVogelaarJul 23, 2024MVP
I'm afraid I don't understand, sorry.
- TimurS1976Jul 23, 2024Copper ContributorEach 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.
- HansVogelaarJul 23, 2024MVP
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.