How to Use the MDURATION Function in WPS on Windows

Last updated:July 20, 2026

Use MDURATION through 4 how-to topics, including entering the function, filling arguments with cell references, combining it with other formulas, and checking input errors; all 4 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter the MDURATION functionFree
22. Use cell references for argumentsFree
33. Combine MDURATION with other formulasFree
44. Check and correct input errorsFree

How-to Guide

1. Enter the MDURATION function

Entry point: Open WPS Spreadsheet → Select the target cell → Formula bar

  1. Open your workbook and select the cell where you want the result to appear.
  2. Type = to start the formula.
  3. Enter MDURATION(.
  4. Continue filling in the required arguments and close the parenthesis.
  5. Press Enter to return the result.

Success Criteria

  • On-screen result: The target cell shows a calculated result.
  • What you can do next: Select the cell again to review the full formula in the formula bar.

Tips While Using

  • Start the formula with =.
  • Use standard parentheses and separators for the function arguments.

2. Use cell references for arguments

Entry point: Result cell → Formula bar

  1. Enter the settlement date, maturity date, coupon rate, yield, payment frequency, and basis in separate cells first.
  2. In the result cell, type =MDURATION(.
  3. Click each parameter cell in order so the references are inserted into the formula.
  4. Complete the separators and closing parenthesis, then press Enter.

Success Criteria

  • On-screen result: The formula shows cell references.
  • What you can do next: When you change a parameter cell, the result updates automatically.

Tips While Using

  • Keep date arguments in a valid date format.
  • Make sure coupon rate, yield, and frequency are entered as valid numeric values.

3. Combine MDURATION with other formulas

Entry point: Analysis area cell → Formula bar

  1. Complete the basic MDURATION calculation first.
  2. Reference the MDURATION result from another cell.
  3. Combine it with yield changes, price estimates, or custom analysis columns.
  4. Save the workbook for later reuse.

Success Criteria

  • On-screen result: The analysis area shows referenced results and derived calculations.
  • What you can do next: When source parameters change, related analysis columns update as well.

Tips While Using

  • Add clear headers for key inputs and result columns.
  • In more complex models, place intermediate results in separate columns for easier review.

4. Check and correct input errors

Entry point: Formula cell with an error → Formula bar

  1. Select the cell that returns an error value.
  2. Check whether the parentheses, separators, and number of arguments are complete.
  3. Review the date order, frequency value, and numeric formats.
  4. Correct the formula and press Enter to recalculate.

Success Criteria

  • On-screen result: The error value is cleared and a normal result appears.
  • What you can do next: The formula continues to recalculate after later parameter changes.

Tips While Using

  • If a referenced cell is blank, the result may not return as expected.
  • Test the formula structure with sample data before applying it across a larger sheet.