please help can not figure out the equation to place in for Excel

You received partial credit in the previo On January 1, Ruiz Company red bonds as follows CD 1. Ruiz Company issued bonds as follows Face Value S 500.000 Number of Years E LL 30 Stated Interest Rate: 74 Interest payments per year Note: the bonds pay interest annually.) 9 Required: 10 1) Calculate the bond selling price given the two market interest rates below. 11 Use formulas that reference data from this worksheet and from the appropriate future or 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required 14 Market Interest Rate: N S 35,000.00 Annual Interest Payment: PV of Face Value + PV of Interest Payments: -Leond Selling Price R $ 397.263 46 Market Interest Rate: 5.594 Annual Interest Payment: S 35,000.00 laulu - y of si present Value of Annuity of 51 Sheet1 READY E E - 100% Step 1 of 1 cells highlighted in red have been filled automatically as they are partially attempted luft blank, incorrect responses (or attempts exhausted). Cells highlighted in green are the correct responses Prey 1 of 2 Nex X On January 1, Ruiz Company issued bonds as follows: R $ 35,000.00 Annual Interest Payment: PV of Face Value: + PV of interest Payments: Bond Selline Price R S 397 268 46 HABARI NR Market Interest Rate: 5.5% V S 35,000.00 Annual Interest Payment: py of Face Value: PV of Interest Payments Bond Selling Price: S 609,003.09 2. Use the Excel IF function to answer either "Premium" or "Discount to the following items. The bond in (a) sold at a: Roscount NRRRRRR N The bond in (b) sold at a: premium . .. y of si Present Value of Annuity of $1 Sheet1 2 - T + 100% Step 1011 Cells highlighted in red have been filled automatically as they are partially attempted, left blank, incorrect responses (or attempts exhausted). Cells highlighted in green are the correct responses