PRICEMAT
PRICEMAT helps you return the price of a security that pays interest at maturity. It provides the tools you need to enter the function correctly, review its syntax, and troubleshoot calculation issues, making your work more efficient and helping you accomplish tasks with ease. With PRICEMAT, you can insert the function through the function dialog, type =PRICEMAT(...) directly in a cell or formula bar, view the syntax PRICEMAT(settlement, maturity, issue, rate, yld, [basis]), and open detailed help for parameter guidance. Whether you're checking parameter data types, correcting text or spaces that cause #VALUE! errors, evaluating unexpected results, or filling the formula across multiple cells while managing relative and absolute references, PRICEMAT helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.