Loss1003
02-13-2012, 09:45 AM
I’m using the formula shown below in column “F” to calculate any losses over the amount listed in cell 4, column “F” ($2,500).
=IF(G4>F7,0,F7-G4)
However, when I copy and insert new rows via (Sub InsertRowsAndFillFormulas(Optional vRows As Long = 0) ' Documented: http://www.mvps.org/dmcritchie/excel/insrtrow.htm (http://www.mvps.org/dmcritchie/excel/insrtrow.htm))
The formula does not work correctly. The formula adds one to G4 and makes it G5. I need the formula to keep G4 in case the user wants to edit the 2,500 to another number. Any help or guidance is appreciated.
=IF(G4>F7,0,F7-G4)
However, when I copy and insert new rows via (Sub InsertRowsAndFillFormulas(Optional vRows As Long = 0) ' Documented: http://www.mvps.org/dmcritchie/excel/insrtrow.htm (http://www.mvps.org/dmcritchie/excel/insrtrow.htm))
The formula does not work correctly. The formula adds one to G4 and makes it G5. I need the formula to keep G4 in case the user wants to edit the 2,500 to another number. Any help or guidance is appreciated.