How to you enter formula to get bond selling price on excel

On January 1, Ruiz Company issued bonds as follows: Face Amount $ Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest semi-annually.) 500,000 15 8% 2 Required: 1) Given the different market interest rates below, calculate the following items. Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all function arguments as cell references. a) Market Interest Rate: Semi-annual interest payment: Bond Selling Price: 9% 20,000 b) Market Interest Rate: Semi-annual interest payment: Bond Selling Price: 6.0% 20,000 $