Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: PRICE function

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

What is PRICE function in Excel? PRICE function is one of the Financial functions in Microsoft Excel that returns the price per $100 face value of a security that pays periodic interest. Syntax of PRICE function PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) The PRICE function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is…