I have the following calculation in each cell of column G in my spreadsheet.

=IF(G53=0,G52, IF(F53>G53,F53,G53))

Each row in the sheet represents the data for the current month compared with the data in the previous month, so this formula is comparing the data in row 54 against the data in row 53. Column G represents a "high water mark" and the formula looks to see if the data in column F is ever higher than the data in column G and if it is then column G takes on that higher value.

That all works fine once I have data in a row, but at the start of each month I start a new row by manually adding data, left to right, in columns A through F, and the problem is that when I do that column G remains blank even though the formula is already in place in column G. The problem resolves itself, that is a value is calculated in column G, if I copy-paste-special (Formulas) from the previous row into the new row.

Is there some way for me to force Excel to calculate the value in column G of the new row without doing that?