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 added to the cost of the ring, if not, the student only pays the base price. Use appropriate relative and absolute cell references. 70 Clipboard Font Alignment Number Format as Table Cell Styles Open recovered workbooks? Your recent changes were saved. Do you want v fe ES C D E F G H 1 Inland Jewelers 2 Date 8/25/21 Name 4 Total Years Monthly Payment Ring Cost Personalized Type Silver $ 400.00 Yes Gold $ 550.00 Yes Titanium $ 700.00 No Platinum $ 750.00 No Platinum $ 750.00 Yes Gold $ 550.00 No Titanium $ 700.00 Yes 1 1 2 3 2 3 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost Personalizing Surcharge 5% 21 Interest Rate 3% 26 27 28 29