How to Use Excel ACCRINTM Function in Office 365? -[with Examples]
Tags: excelaccrintmfunctio, excelfunctions
Published: 2020-09-29 09:39:57

---
title: How to Use Excel ACCRINTM Function in Office 365? -[with Examples]
published: true
date: 2020-09-29 07:09:46 UTC
tags: ExcelACCRINTMFunctio,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-accrintm-function-in-office-365-with-examples/
---

## Excel ACCRINTM Function:

[![ACCRINTM Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/ACCRINTM-Function.png)](https://geekexcel.com/?attachment_id=14766#main)<figcaption id="caption-attachment-14766">ACCRINTM Function</figcaption>

In this article, we are going to explore how to use the **Excel ACCRINTM Function Office 365** with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **ACCRINTM Function – Explanation:**

- This function **returns the accrued interest for a security that pays interest at maturity (ending date)**.

## **Syntax:**

**=ACCRINTM(id, sd, rate, par, [basis])**

### Arguments Explanation:

**id – ** This is the issue date of the security.

**sd – ** Settlement date of the security.

**rate – ** It is the annual coupon rate.

**par – ** Par value of the security.

**basis – ** It is an optional one. This is the type of day count basis. The default value is 0.

### Note:

- If dates are invalid, then this function returns the [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- This function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) when it meets any criteria given below:
  - Issue date >= Settlement date
  - Rate < 0 or Par <= 0
  - The basis is out of range.

## **Examples:**

Let’s see some examples to understand how this function works.

### Example 1:

- In this screenshot, you can see the **input numbers** are given in **Column**  **C** and the **output value** is **displayed** in **Cell E4.**

[![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-1-4.png)](https://geekexcel.com/?attachment_id=14763#main)<figcaption id="caption-attachment-14763">Example 1</figcaption>

### Example 2:

- If dates are invalid, then this function returns the [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

[![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-2-5.png)](https://geekexcel.com/?attachment_id=14764#main)<figcaption id="caption-attachment-14764">Example 2</figcaption>

### Example 3:

- In the below image, you can see the **Annual coupon rate** is given as **negative value** ( **less than 0** ), So it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

[![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-3-3.png)](https://geekexcel.com/?attachment_id=14765#main)<figcaption id="caption-attachment-14765">Example 3</figcaption>

## **Wrap-Up:**

In this article, you can clearly understand the usage of **Excel ACCRINTM Function Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Article:

- [**ACCRINT Function in Excel**](https://geekexcel.com/how-to-use-excel-accrint-function-in-office-365-with-examples/)

### Keep Reading:

- [How to Use Excel IRR Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-irr-function-in-office-365-with-examples/)
- [How to Use Excel DOLLARDE Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-dollarde-function-in-office-365-with-examples/)