Formulas > =PRICEMAT()
How to Use PRICEMAT() in Google Sheets
Description
How To Actually Use PRICEMAT() in Sheets
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
Try PRICEMAT yourself
Use the PRICEMAT formula in cell D1 to calculate the price of a security. The settlement date is in A1, maturity date in B1, issue date in C1, interest rate in D1, and yield in E1.
Hints (3)
-
Make sure to reference the correct cells for each argument.
-
Check that the dates are formatted correctly.
-
Remember that the interest rate and yield should be in decimal form.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the PRICEMAT() formula:
Generate a PRICEMAT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PRICEMAT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PRICEMAT() formula