How to Use the MDURATION Function in WPS on Windows

Last updated:July 17, 2026

Use the MDURATION function in 4 topics on WPS Spreadsheet for Windows; choose a topic from the How-to Index and follow the steps to complete the task.

How-to Index

No.TopicMembership Requirement
11. Enter the MDURATION functionFree
22. Fill in the function arguments with promptsFree
33. Use cell references to complete the calculationFree
44. Fix errors or recalculate the resultFree

How-to Guide

1. Enter the MDURATION function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = to start a formula.
  3. Continue by typing MDURATION(.
  4. Check whether the function name and syntax prompt appear.

Success Criteria

  • Interface result: The cell enters formula-editing mode and shows the MDURATION prompt.
  • What you can do next: You can continue entering arguments or reference other cells.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.
  • Environment note: Complete this task in a WPS Spreadsheet worksheet.

2. Fill in the function arguments with prompts

Entry point: Function prompt in the formula bar

  1. After MDURATION(, enter the required arguments in order.
  2. Fill in the settlement date, maturity date, coupon, yield, frequency, and basis as prompted.
  3. Separate arguments with commas.
  4. Type the closing parenthesis ) and press Enter.

Success Criteria

  • Interface result: The cell returns a calculated value, and the formula bar shows the full MDURATION formula.
  • What you can do next: You can edit any argument and get an updated result.

Tips While Using

  • Common mistake: Missing parentheses, too few arguments, or incorrect separators can trigger a formula error.
  • Environment note: Keep date and numeric arguments in valid calculation formats.

3. Use cell references to complete the calculation

Entry point: Worksheet cells + formula bar

  1. Put the settlement date, maturity date, coupon, and other arguments into worksheet cells.
  2. In the result cell, type =MDURATION(.
  3. Click each argument cell in order to insert cell references.
  4. Complete the formula and press Enter.

Success Criteria

  • Interface result: The result cell shows a calculated value, and the formula contains cell references.
  • What you can do next: When you change any argument cell, the result can update with it.

Tips While Using

  • Common mistake: Referencing text-formatted numbers or invalid dates can affect the result.
  • Environment note: For cross-sheet references, confirm that the referenced cells are valid.

4. Fix errors or recalculate the result

Entry point: Result cell → formula bar / worksheet recalculation

  1. If the result shows an error, check the parentheses, argument order, and separators first.
  2. Check whether the referenced cells contain valid dates, rates, and frequency values.
  3. After editing the arguments, press Enter to confirm the formula again.
  4. If needed, trigger worksheet recalculation and review the updated result.

Success Criteria

  • Interface result: The error message disappears or the result updates to a new calculated value.
  • What you can do next: You can continue copying the formula, saving the workbook, or using the result in later analysis.

Tips While Using

  • Common mistake: Numbers stored as text can cause unexpected results.
  • Environment note: In complex workbooks, confirm that related reference chains have updated.