I have created a formula in cell A3 that subtracts A2 from $A$1, where A2 nd A1 refers to a simple number formats, no formulas. My formulas written in cell A3 reads: =$A$1-A2). However, when inserting a new row, in order to enter a new cell of data immediately above the formula, I notice that the formula does not change and continues to refer to A2, the "old" cell entry. However, I desire the formula to change to =$A$1-A3 and then to =$A$1-A4 when another new row is inserted and so on. . Basically I am trying to find simple non-vba method (of one exists) that will force this formula refer to the "new cell" I insert in the column immediately above it and subtract it from $A$1.
Any suggestions on writing a formula on will adjust automatically when a new row is inserted? Mahalo in advance.
Any suggestions on writing a formula on will adjust automatically when a new row is inserted? Mahalo in advance.
