ACCRINTM()
Syntax. ACCRINTM(Issue,Settlement,Nominal_Interest,Par_Value,Basis)
Definition. The function ACCRINTM() calculates the accrued interest of a debt due in full intra-annually or the accrued interest of a fixed-interest security with one interest payment per year.
Arguments
Issue (required) The date of the issue of the security.
Settlement (required) The date when the ownership of the security changes.
Nominal_Interest (required) The agreed-upon interest rate of the security based on one year.
Par_Value (optional) The nominal value of the security. If this argument is not specified, Excel calculates with 1000 monetary units (contrary to the information in Excel Help in Excel 2003 and earlier versions).
Basis (optional) Defines the method you ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
