Function Type: Financial
Description:
Returns the price per $100 face value of a discounted security.
Function Structure:
=PRICEDISC(settlement, maturity, discount, redemption, [basis]).
Argument Breakdown:
settlement – Settlement date of the security.
maturity – Maturity date of the security.
discount – Discount rate of the security.
redemption – Redemption value per $100 face value.
basis – Day count basis.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.