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 allowing me to Rt Click – Insert or Delete a row. I then select all data between B2 and M50, then I drag and drop all of those cells down one row, to create an empty row of data. Reason being, to add 632 before 637 at B1. When I do this, the data in Column K creates an Inconsistent Formula.

Notice in the screenshot below where the formulas beginning on Row 16 at K16, it begins to repeat the above formula (I15). It should read “=901.2-I16” as opposed to “=901.2-I15”

Please advise.

​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 allowing me to Rt Click – Insert or Delete a row. I then select all data between B2 and M50, then I drag and drop all of those cells down one row, to create an empty row of data. Reason being, to add 632 before 637 at B1. When I do this, the data in Column K creates an Inconsistent Formula. Notice in the screenshot below where the formulas beginning on Row 16 at K16, it begins to repeat the above formula (I15). It should read “=901.2-I16” as opposed to “=901.2-I15″Please advise.  Read More

​