Insert an IF function in cell E$5$ to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of $5\%$ located in cell B$21$ that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references. B Monthly Ring Type Personalized Total Name Cost Years Payment $45$ Dodson $ $400\mathrm{.}00$ Yes Silver $ $550\mathrm{.}00$ Yes Titanium $ $700\mathrm{.}00$ No $6$ Jones Gold $7$ Clarke $8$ Ranger $9$ McKinley $10$ Broadnax $11$ Burch $2$ Platinum $ $750\mathrm{.}00$ No Platinum $ $750\mathrm{.}00$ Yes Gold $ $550\mathrm{.}00$ No $2$ $ $700\mathrm{.}00$ Yes Titanium $12$ Totals $1314$ Ring Type $15$ Cost $ $400\mathrm{.}00$ $ $550\mathrm{.}00$ $ $700\mathrm{.}00$ $ $750\mathrm{.}0016$ Silver $17$ Gold $18$ Titanium $19$ Platinum $20$ Personalizing $5\%$ Surcharge $213\%22$ Interest Rate