Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: PRICEDISC function

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

What is PRICEDISC function in Excel? PRICEDISC function is one of Financial functions in Microsoft Excel that returns the price per $100 face value of a discounted security. Syntax of┬áPRICEDISC function PRICEDISC(settlement, maturity, discount, redemption, [basis]) Important:┬áDates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd…