How to Use the PDURATION Function in WPS on Windows

Use the PDURATION function through 4 how-to topics, including entering the formula, filling in parameters, combining references and nested formulas, and checking recalculation results.

How-to Index

How-to Guide

1. Enter the PDURATION 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. Type PDURATION(.
4. Get ready to enter the function arguments.

Success Criteria

• Interface result: the selected cell enters formula editing mode.
• What you can do next: you can continue entering rate, pv, and fv.

Tips While Using

• Common mistake: if you do not start with =, the content is treated as plain text.
• Environment note: make sure you are editing a worksheet cell that accepts formulas.

2. Fill in parameters with syntax prompts

Entry point: formula bar or active cell

1. After typing PDURATION(, review the syntax prompt shown by the app.
2. Enter the fixed rate, present value, and future value in order.
3. Separate the arguments with commas.
4. Type the closing parenthesis ).
5. Press Enter to confirm.

Success Criteria

• Interface result: the cell displays a calculated result.
• What you can do next: select the cell again to review the full formula in the formula bar.

Tips While Using

• Common mistake: unmatched parentheses or missing separators can cause an error.
• Environment note: use valid numeric inputs instead of unsupported text values.

3. Use cross-sheet references and nested formulas

Entry point: formula bar

1. Insert references to cells in the current worksheet or another worksheet where needed.
2. If you need a combined calculation, place another function result inside a PDURATION argument.
3. Check that the references and formula structure are correct.
4. Press Enter to confirm the formula.

Success Criteria

• Interface result: the cell returns an updated calculation result.
• What you can do next: edit referenced cells and continue observing result changes.

Tips While Using

• Common mistake: an incorrect sheet name or cell reference can affect the result.
• Environment note: nested formulas should return valid numeric values before PDURATION evaluates them.

4. Check results and recalculation

Entry point: result cell and referenced cells

1. Review the current PDURATION result in the selected cell.
2. Change the rate, present value, or future value used by the formula.
3. Check whether the result updates when the referenced data changes.
4. If the result looks wrong, review cell formats, argument order, and formula structure.

Success Criteria

• Interface result: the result updates when referenced values change.
• What you can do next: save, copy, or extend the formula to other cells.

Tips While Using

• Common mistake: text-formatted numbers, circular references, or incorrect argument order can affect the result.
• Environment note: if worksheet calculation behavior seems unusual, review the formula and recalculate if needed.