Common DISC questions on Windows usually involve errors, unexpected results, and filling formulas across cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if DISC returns a #VALUE! error?
- Check whether each argument uses the correct data type and make sure numeric arguments do not contain text or extra spaces.
- Check whether the date arguments are recognized as valid dates.
- If needed, clean the source data and enter the formula again.
Why does the DISC result look different from what I expected?
- Check whether
settlement,maturity,pr,redemption, andbasisare in the correct positions. - Make sure the related cells use number or date formats instead of text format.
- Review the formula step by step to verify the calculation.
How do I use the DISC function in multiple cells?
- Enter the correct DISC formula in the first target cell.
- Select that cell and drag the fill handle across the target range.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| settlement | The security settlement date, which is the date when the traded security is delivered to the buyer. |
| maturity | The maturity date of the security, which is the date when the security reaches redemption. |
| basis | The day count basis used to determine how days are counted between dates. |