Forum Discussion
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 ...
If I have a formula in J15
=1000-I15and then insert cells in or above those cells, the formula is now in J16 and reads
=1000-I16The only way the formula would remain
=1000-I15would be if I pushed J15 down but not I15. So I don't see how you got to the situation you show.
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.
I cannot reproduce or explain that...
- Thanks
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.
