Row 1 is a series of years, 2020, 2021, etc. Row 2 is projected balances in an investment account. I want to add a hard number to the account balances entered into row three in a given year which I enter in row 4. I want Excel to recalculate the series of balances automatically as I change the year I enter in row 4.

Thanks in advance.