DISC in WPS on Windows FAQ

Last updated:July 20, 2026

When using DISC, the most common questions involve formula errors, argument meaning, unexpected results, and recalculation checks; this FAQ covers 4 frequent questions.

FAQ

What should I do if the DISC function returns an error?

  1. Check whether the formula starts with =.
  2. Review brackets, separators, and the number of arguments.
  3. Confirm that dates, price, and redemption value use valid formats.
  4. Re-enter the formula and press Enter again.

How can I view the argument help for the DISC function?

  1. Select the target cell.
  2. Type =DISC(.
  3. Review the syntax prompt that appears.
  4. Fill in the arguments in the displayed order.

Why does the DISC result look incorrect?

  1. Check whether referenced cells contain numeric values instead of text-formatted numbers.
  2. Confirm that the settlement date and maturity date are correct.
  3. Review the price, redemption value, and basis settings for the current calculation.
  4. Update the arguments and compare the result again.

Why did the result not change after I edited the data?

  1. Make sure you edited the cells actually referenced by the formula.
  2. Check whether the cell edits were applied successfully.
  3. Select the formula cell again and confirm that the formula structure is still correct.
  4. If needed, re-enter the formula to verify the calculation.

Glossary

TermDefinition
DISCA financial function used to calculate the annual discount rate of a discounted security.
Settlement dateThe date when a security transaction is completed and enters settlement.
Maturity dateThe date when the security reaches redemption or final payment.
Redemption valueThe amount paid when the security is redeemed at maturity.