Click the New Prices sheet tab and review the Formula bar.

Click cell D$5.$ The formula begins with $1+$D$4.$

Edit and copy a formula with mixed references.

Edit the formula in cell D$5$ to show D$$4$ instead of $"$D$4."$ The formula should multiply one plus the percentage value in cell D$4$ by the current rate on the Fleet sheet $($$H$5).$ With an absolute reference to row $4$ and column H on the Fleet sheet, you can copy the formula down the column