Question

edit the formula in cell d2 so the references to cell c2

Answer 1

Double-click cell C2 to edit the formula. Change the formula to be =B2+(B2*$B$9). Press Enter. Edit the formula in cell C2 so the references to cell B2 will update when the formula is copied, and the reference to cell B9 will remain constant.