MDURATION in WPS on Windows FAQ

Last updated:July 17, 2026

When using MDURATION, the most common questions involve formula entry, argument formats, and result checks; this FAQ includes 3 common questions and a glossary.

FAQ

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

  1. Check whether the formula starts with =.
  2. Check whether the parentheses are paired correctly and whether the separators are correct.
  3. Confirm that the argument types and count match the function requirements.
  4. If you use cell references, make sure the referenced cells contain valid dates or numbers.

How can I view the argument guidance for the MDURATION function?

  1. Type =MDURATION( in a cell.
  2. Look for the syntax prompt near the formula bar.
  3. Review each argument position in the prompt before completing the formula.
  4. If needed, organize the input values in nearby cells first and then reference them.

Why does the MDURATION result look incorrect?

  1. Check whether the settlement date and maturity date are correct.
  2. Check whether the coupon, yield, and frequency use the intended values.
  3. Check whether referenced cells contain text-formatted numbers or blank values.
  4. Recalculate after editing and compare the result with your expected scenario.

Glossary

TermDefinition
MDURATIONA financial function in WPS Spreadsheet that returns the modified duration of a security with an assumed par value of 100.
Settlement dateThe date when a security trade is settled. It is an important input in the calculation.
Maturity dateThe date when the principal of the security is due, which affects the duration result.
Cell referenceA worksheet cell address used in a formula instead of typing the value directly, which helps keep calculations linked and updated.