When using ACCRINT, the most common questions are about errors, result verification, and filling the formula across multiple cells; this section includes 3 frequent questions and a glossary.
FAQ
Why does ACCRINT return a #VALUE! error?
- Check whether the cells used for issue, first_interest, and settlement contain valid dates or numbers.
- Make sure the arguments do not include text, extra spaces, or invalid formatting.
- If the data comes from another table, clean the values and enter the formula again.
Why is the ACCRINT result different from what I expected?
- Check whether the references and argument order are correct, especially for dates, rate, par, and frequency.
- Confirm that the related cells are formatted as numbers or dates instead of text.
- Review whether
basisandcalc_methodmatch the interest-counting rule for the security.
How to use the ACCRINT function in WPS across multiple cells?
- Enter the full ACCRINT formula in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag downward, or copy and paste the formula into other target cells.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| ACCRINT | A financial function used to calculate the accrued interest of a security that pays periodic interest. |
| basis | The day-count basis used to determine which day-count rule is applied in the interest calculation. |
| calc_method | An optional argument that controls the starting point used for the accrued-interest calculation. |