Formulas > =ACCRINTM()
How to Use ACCRINTM() in Google Sheets
Description
How To Actually Use ACCRINTM() in Sheets
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Try ACCRINTM yourself
Use the ACCRINTM formula to calculate the accrued interest for a security with the issue date in cell A1, maturity date in cell A2, interest rate in cell A3, and redemption value in cell A4. Place your answer in cell B1.
Hints (2)
-
Make sure to reference the correct cells for each parameter.
-
Remember that the redemption value is optional.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the ACCRINTM() formula:
Generate a ACCRINTM() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ACCRINTM(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ACCRINTM() formula