81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

How To Use in Sheets

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

External Links

Excel PRICEDISC function - how to use PRICEDISC function

The Excel Pricedisc function calculates the price, per $100 face value of a discounted security.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.