Formulas > =PRICEDISC()

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

Transcript-matched member videos for PRICEDISC(). Click through to watch.

Watch more tutorials

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Pricing Strategies for Spreadsheets

Pricing is an art. Learn to balance affordability with profitability, un...

Intermediate

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

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

How to Use PRICEDISC() in Google Sheets

Try PRICEDISC yourself

More related tutorials

Ultimate Checklist in Google Sheets

Pricing Strategies for Spreadsheets

Write Apps Script to Create a New Google Sheets Formula