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. […]