DURATION in WPS on Windows FAQ

When using the DURATION function, the most common questions fall into 3 areas: syntax errors, argument understanding, and unexpected results; this FAQ includes 4 common questions.

FAQ

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

1. Check whether the formula starts with =.
2. Check whether brackets, separators, and argument count are complete.
3. Confirm that the date, coupon, yield, and frequency arguments use valid formats.
4. Submit the formula again and review the result.

How do I view argument prompts for the DURATION function?

1. Select the target cell.
2. Type =DURATION(.
3. Review the syntax prompt shown in the formula editing area.
4. Fill in the arguments in order and complete the calculation.

Why does the DURATION result look incorrect?

1. Check whether referenced cells contain numbers stored as text.
2. Confirm that the settlement date is earlier than the maturity date and that the frequency argument uses a valid value.
3. Check whether the optional basis argument matches the calculation method you need.
4. Update the arguments and compare the result again.

Can I use the DURATION function with other formulas?

1. Yes. You can calculate intermediate values in other cells first.
2. Reference those intermediate results inside the DURATION formula.
3. You can also nest other functions directly inside DURATION arguments.
4. After that, review the full formula to keep it easy to maintain and check.

Glossary