Formulas > =PRICEDISC()

# How To Use PRICEDISC() Function in Google Sheets

Description

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

Common Questions about the PRICEDISC Formula:
- What does the PRICEDISC formula do?
- How do I calculate discounted prices with the PRICEDISC formula?
- How do I format the PRICEDISC formula in Google Sheets?

How to Use the PRICEDISC Formula Appropriately:
- Enter the PRICEDISC formula into the cell where you want to calculate discounted price.
- Your inputs should be the original price (before discount), the discount rate, and the number of months the discount should apply for.
- Multiply the original price by the discount rate to get the discounted price.

How the PRICEDISC Formula is Commonly Mistyped:
- Using brackets instead of parentheses
- Leaving out inputs, such as the original price and the discount rate
- Reversing the order of inputs
- Also mistyped as PRICEDSC, PRCEDISC, PRICDISC, PRICDSC.

Common Ways the PRICEDISC Formula is Used Inappropriately:
- Placing the inputs in the wrong order
- Not accounting for tax or other extra charges
- Not converting currency values to the same currency

Common Pitfalls When Using the PRICEDISC Formula:
- Entering the inputs as strings instead of numbers
- Incorrectly formatting inputs to the formula
- Not updating the formula when entries in the original range change

Common Mistakes When Using the PRICEDISC Formula:
- Not including all inputs when entering the formula
- Not accounting for rounding errors when calculating the discount
- Not allowing for additional charges such as taxes when calculating the discount

Common Misconceptions People Might Have With the PRICEDISC Formula:
- Thinking the formula can automatically convert currency
- Thinking the formula can automatically calculate taxes
- Thinking the formula can handle complex discount scenarios (such as multiple tiers of discounts) automatically.

How To Actually Use PRICEDISC() in Sheets

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

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

Excel PRICEDISC function - how to use PRICEDISC function

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

Generate a PRICEDISC() formula for your needs with AI

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets