Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: PRICEMAT function

PRICEMAT function: Description, Usage, Syntax, Examples and Explanation

What is PRICEMAT function in Excel? PRICEMAT function is one of Financial functions in Microsoft Excel that returns the price per $100 face value of a security that pays interest at maturity. Syntax of PRICEMAT function PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example,…