Formulas > =DISC()
How to Use DISC() in Google Sheets
Description
How To Actually Use DISC() in Sheets
DISC(settlement, maturity, price, redemption, [day_count_convention])
Try DISC yourself
Use the DISC formula to calculate the discount rate for a security with the settlement date in A1, maturity date in B1, price in C1, and redemption value in D1. The result should be displayed in E1.
Hints (3)
-
Ensure the dates in A1 and B1 are formatted correctly.
-
Price and redemption values should be numeric.
-
Remember to check the order of arguments in the DISC function.
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
More related tutorials
Transcript-matched member videos for DISC(). Click through to watch.
Ultimate Checklist in Google Sheets
Learn Google Sheet Formulas The Hard Way
Learn more about the DISC() formula:
Generate a DISC() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses DISC(). 2 free AI generations, no signup. Members get unlimited use.
Generate a DISC() formula