This FAQ focuses on 3 common question types for the MDURATION function, including errors, result checking, and batch use in worksheets.
FAQ
What should I do if MDURATION returns a #VALUE! error?
- Check whether each argument uses the correct data type and make sure numeric arguments do not contain text or extra spaces.
- Confirm that date arguments are valid dates instead of plain text.
- Clean the source data if needed, then enter the formula again.
Why does the MDURATION result look different from what I expected?
- Check whether settlement, maturity, coupon, yield, frequency, and basis are entered correctly.
- Confirm that the referenced cells are correct and that the cell formats support calculation.
- Review the arguments one by one, then calculate again if needed.
How can I use MDURATION in multiple cells at once?
- Enter the full MDURATION formula in the first target cell.
- Move the pointer to the fill handle at the lower-right corner of the cell and drag down or across.
- After filling, check whether relative and absolute references match your intended result.
Glossary
| Term | Definition |
|---|---|
| MDURATION | A financial function that returns the modified Macauley duration of a security. |
| settlement | The settlement date of the security, which is the delivery date after the trade. |
| maturity | The maturity date of the security, when the security expires. |
| coupon | The annual coupon rate of the security. |
| basis | A day-count basis argument used to define the date calculation method. |