When using ACCRINTM, users usually run into 3 common issue types: parameter errors, unexpected results, and batch fill questions; this section answers 3 frequent questions.
FAQ
What should I do if ACCRINTM returns a #VALUE! error?
- Check whether the parameter data types are correct, especially dates and numeric values.
- Remove extra spaces or text formatting if the source cells were pasted from another location.
- Confirm that the date inputs are valid dates and that the formula uses English commas as separators.
Why does the ACCRINTM result look different from what I expected?
- Check whether the referenced cells are correct.
- Verify that the syntax is
ACCRINTM(issue, settlement, rate, par, [basis]). - Review the cell formats and confirm that the basis and other inputs match your calculation needs.
How can I use ACCRINTM in multiple cells at once?
- Enter the full ACCRINTM formula in the first target cell.
- Drag the fill handle across the target range, or copy and paste the formula.
- After filling, review relative and absolute references and use
$where needed.
Glossary
| Term | Definition |
|---|---|
| ACCRINTM | A financial function used to calculate accrued interest for a security that pays interest at maturity. |
| issue | The issue date of the security and the starting date parameter in the function. |
| settlement | A date parameter used in the accrued-interest calculation. |
| par | The par value or face value used as the amount parameter. |
| basis | The day-count basis parameter that controls how the date difference is calculated. |