How to Use PRICEDISC() in Google Sheets

Description

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

How To Actually Use PRICEDISC() in Sheets

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

Try PRICEDISC yourself

Use the PRICEDISC formula to calculate the price of a discount security based on the data in cells A1:D1. The settlement date is in A1, maturity date in B1, discount rate in C1, and redemption value in D1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the PRICEDISC() formula:

Generate a PRICEDISC() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses PRICEDISC(). 2 free AI generations, no signup. Members get unlimited use.

Generate a PRICEDISC() formula