Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 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 4 5 Dodson $ 400.00 Yes Silver $ 550.00 Yes Titanium $ 700.00 No 6 Jones Gold 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 2 Platinum $ 750.00 No Platinum $ 750.00 Yes Gold $ 550.00 No 2 $ 700.00 Yes Titanium 12 Totals 13 14 Ring Type 15 Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Personalizing 5% Surcharge 21 3% 22 Interest Rate