PRICEDISC

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:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->