How do I get the Price using excel function?

1 Westco Co. issued 15-year bonds a year ago at a coupon rate of 5.4 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 4.5 percent, what is the current price of the bond 2 fin dollars? 3 4 Input area: 5 6 Settlement date 1/1/2020 7 Maturity date 1/1/2034 8 Coupon rate 5.40% 9 Coupons per year 2 10 Redemption value (% of par) 100 11 Yield to maturity 4.50% 12 Par value $1,000 13 14 function to answer this question. Leave the Basis input blank in the function. You may enter a constant 15 as a hard coded value.) 16 17 Output area: 18 19 Price (% of par) 109.274 20 Price $1,141.74 21 22 23