How to use the YIELD function in Excel Office 365?
Tags: tousetheyieldfunctio, excel, excelfunctions
Published: 2021-08-26 02:06:20

---
title: How to use the YIELD function in Excel Office 365?
published: true
date: 2021-08-23 15:58:50 UTC
tags: ToUseTheYIELDFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-yield-function-in-excel-office-365/
---

 **YIELD function** in Excel returns is calculated using some **arguments based on terms on security**. Here, we will show the formulas to **use the YIELD Function In Excel Office 365**. Let’s jump 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)

## YIELD Function Syntax

```
=YIELD ( Settlement , Maturity, rate , pr, redemption ,frequency , [basis])
```

**Syntax Explanation:**

- **settlement ** – Settlement **date of the security**.
- **Maturity** – maturity **date of the security**.
- **rate** – **Interest rate** of security.
- **pr** – Price per **$ 100 value**.
- **redemption** – **redemption value**.
- **frequency** – **payments per year** (1 = annual, 2 = semi, 4= quarterly).
- **[basis]** – [optional] **Day count basis**. **Default is 0**.

## Example

- Firstly, you need to create **sample data with value and arguments**.

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

- Then, you have to calculate the **yield percent** for the security.
- Now, you need to use the following **formula** given below.

```
=YIELD(A2,A3,A4,A5,A6,4,0)
```

- **4** : **quarterly payment, number of payments** per year
- **Basis** : basis is optional argument **default is 0**.

![](https://geekexcel.com/wp-content/uploads/2021/08/YIELD-percent-1024x471.png)<figcaption>YIELD Percent</figcaption>

- Finally, you have to change the format of the cell from **Number to Percent** in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/08/convert-to-percent-1024x478.png)<figcaption>Convert to percent</figcaption>

**Check this too:** [How to use the TBILLYIELD function in Excel office 365?](https://geekexcel.com/how-to-use-the-tbillyield-function-in-excel-office-365/)

**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**.
- You need to check the **date values** if the function returns **#VALUE! Error**.
- Then, the **security settlement date** is the date after the issue date when the security is traded to the buyer.
- Now, the arguments like **settlement date & maturity date** , **frequency & 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**.
- Finally, the function returns the **#NUM! Error** if:
  - If maturity date settlement value.
  - If the **basis argument** is **either < 0 or  > 4**
  - **Payment Frequency** argument is **not one of the three** (1, 2 or 4).
  - If **rate argument is < 0**
  - If **pr argument ? 0**
  - If **redemption argument is  < 0**

## Summary

We hope that this short tutorial gives you guidelines to **use the YIELD 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 Also:**

- **[Formulas to Count Unique Text Values in a Range in Excel Office 365!!](https://geekexcel.com/formulas-to-count-unique-text-values-in-a-range-in-excel-office-365/)**
- **[Formulas to Count Unique Text Values with Criteria in Excel!!](https://geekexcel.com/formulas-to-count-unique-text-values-with-criteria-in-excel/)**
- **[How to use the TBILLYIELD function in Excel office 365?](https://geekexcel.com/how-to-use-the-tbillyield-function-in-excel-office-365/)**
- **[How to use the TBILLPRICE function in Excel Office 365?](https://geekexcel.com/how-to-use-the-tbillprice-function-in-excel-office-365/)**