This FAQ covers 3 common questions and 3 glossary terms for the DURATION function in WPS Sheets, focusing on argument formats, unexpected results, and filling formulas across cells.
FAQ
What should I do if the DURATION function returns an error value?
- Check whether each argument uses the required data type.
- Make sure date, rate, and frequency values are not being treated as text.
- If the arguments come from other cells, verify that the referenced cells are not empty and use the correct format.
Why does the DURATION result look different from what I expected?
- Check whether settlement and maturity are in the correct order.
- Review coupon, yield, frequency, and basis to make sure they match your calculation conditions.
- If needed, inspect the source values in nearby cells one by one.
How to use the DURATION function in WPS on Windows across multiple cells?
- Enter and confirm the DURATION formula in the first cell.
- Select that cell and drag the fill handle across the target range.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| settlement | The security settlement date, when the security is delivered to the buyer. |
| maturity | The maturity date, when the security expires or is redeemed. |
| basis | The day count basis argument used to determine how dates are calculated. |