How to use the RECEIVED Function in Excel office 365?
Tags: tousethereceivedfunc, excel, excelfunctions
Published: 2021-08-27 10:52:44

---
title: How to use the RECEIVED Function in Excel office 365?
published: true
date: 2021-08-25 18:43:24 UTC
tags: ToUseTheRECEIVEDFunc,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-received-function-in-excel-office-365/
---

The **RECEIVED function** calculates the **amount** which is **received at maturity for a bond** with an **initial investment** (security) and a **discount rate** , there are **no periodic interest payments**. In this tutorial, we will guide you on **how to use the RECEIVED**  **Function In Excel Office 365**. Let’s get them below!! 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)**

## RECEIVED Function Syntax

```
=RECEIVED (settlement, maturity, investment, discount, [basis])
```

**Syntax Explanation:**

- **Settlement** : Settlement date of the security.
- **Maturity** : Maturity date of the security. The maturity date is the date when the security expires.
- **Investment** : amount invested in the security.
- **discount** : The security’s discount rate.
- **basis** : [optional] Day count basis. Default is 0.

## Example

- Firstly, you need to **create a sample data** with **input value**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-34.png)<figcaption>Sample data</figcaption>

- Then, you have to calculate the **amount received at maturity** with an **initial investment** (security) and a **discount rate for a bond** having a **settlement date & maturity date**.
- Now, you need to use the following **formula** given below.

```
=RECEIVED(B1, B2, B3, B4, B5)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Amount-Received.png)<figcaption>Amount Received</figcaption>

- **B1:** Settlement date of the security
- **B2:** Maturity date of the security. The maturity date is the date when the security expires.
- **B3:** investment amount in the security
- **B4:** The security’s annual coupon rate
- **B5:** 0 specifies Day count basis method choose US (NASD) 30 / 360 .[optional]

- After that, all the **arguments** to the **function** is given as **cell reference**.

**Check this too:** [How to use the GAMMA.DIST function in Excel Spreadsheet?](https://geekexcel.com/how-to-use-the-gamma-dist-function-in-excel-spreadsheet/)

**NOTES:**

- Excel stores **dates as serial numbers** and is used in calculation by the **function**.
- It is used to recommend to use **dates as cell reference** instead of giving **direct argument to the function**.
- Arguments **settlement , maturity & basis** are truncated to **integers**.
- After that, the function returns the **#VALUE! Error** if the **settlement date & maturity date** is not a **valid date format**.
- The function returns the **#NUM! Error** if:
  - Investment is less than or equals to zero. Investment 0.
  - Discount is less than or equals to zero. discount 0.
  - If value of argument basis is either < 0 or  > 4. 
  - If maturity settlement.

## End of line

We hope that this tutorial gives you guidelines on **how to use the RECEIVED Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Simple Invoice Template in MS Excel ~ with Example!!](https://geekexcel.com/simple-invoice-template-excel/)**
- **[Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-percentage-discount/)**
- **[Excel Formulas to Find Original Price from Percentage Discount!!](https://geekexcel.com/excel-formulas-to-find-original-price-from-percentage-discount/)**
- **[How to use the MDURATION function in Excel office 365?](https://geekexcel.com/how-to-use-the-mduration-function-in-excel-office-365/)**
- **[How to use the YIELD function in Excel Office 365?](https://geekexcel.com/how-to-use-the-yield-function-in-excel-office-365/)**