Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:D6.

formula = C2 + (C2*$B$9)

Explanation:

given data

Edit the formula in cell = D2

references formula to cell = C2

reference to cell constant = B9

solution

we use here for Auto fill to copy the formula to the cell D3:D6 is express as

Auto fill to copy the formula = C2 + (C2*$B$9) ... 1

and then we will grab little square on the bottom right and drag it to D6