The actual adjustment percentage is entered in cell F6, which is the named rangecola.
The result on each new row is the previous year’s base plus the adjustment.
The result is the total of all adjustments made since year 1.
Cost of living adjustment
To calculate a cost of living (COLA) adjustment in Excel, you can use a simple formula that multiplies the base times the adjustment percentage, then adds the result to the base. In the example shown, the formula in C6, copied down, is: =C5+(C5*cola) where cola is the named range F6, and contains the adjustment as a percentage.
