How to use the TBILLYIELD function in Excel office 365?
Tags: tousethetbillyieldfu, excel, excelfunctions
Published: 2021-08-25 02:36:30

---
title: How to use the TBILLYIELD function in Excel office 365?
published: true
date: 2021-08-20 13:49:58 UTC
tags: ToUseTheTBILLYIELDFu,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-tbillyield-function-in-excel-office-365/
---

 **TBILLYIELD function** returns the **yield on maturity per $100 face value** for a **Treasury bill**. It takes the **settlement date and maturity date as argument dates** along with the price per $100 face value. Here, we will show the formulas to **use the TBILLYIELD 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)

## TBILLYIELD function syntax

```
=TBILLYIELD (settlement, maturity, pr)
```

**Syntax Explanation:**

- **settlement** : Treasury bill’s **settlement date.**
- **maturity** : Treasury bill’s **maturity date.**
- **pr** : Treasury bill’s **price per $100 face value**.

## Example

- Firstly, you have a **settlement date, maturity date** and **price per $100 face value** for the treasury bill.

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

- Then, you need to calculate the **TBILLYIELD function**.
- Now, you have to use the following **formula** given below.

```
=TBILLYIELD(A2,A3,A4)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/TBILLYIELD-function-1024x208.png)<figcaption>TBILLYIELD function</figcaption>

- After that, you have to convert the **decimal value to percentage** by changing the **format of the cell to percentage**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Change-the-value-1024x201.png)<figcaption>Change the value</figcaption>

- Now, you need to calculate the **YIELD function** for the same parameters.

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

**Check this too:** [How to use the BETA.DIST function in Excel office 365?](https://geekexcel.com/how-to-use-the-beta-dist-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** 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 maturity **date settlement value**.

## Conclusion

In this short tutorial, we explained how to **use the TBILLYIELD Function In Excel Office 365**. If you have any queries, leave them in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

**Continue Reading:**

- **[Formulas to Lookup a Latest Price ~ A Complete Tutorial!!](https://geekexcel.com/lookup-a-latest-price-excel-formula/)**
- **[Excel Date and Time Functions in Office 365!!](https://geekexcel.com/date-and-time-functions-in-microsoft-excel-365/)**
- **[How to Select Cells with Error Values in Excel Office 365?](https://geekexcel.com/how-to-select-cells-with-error-values-in-excel-office-365/)**
- **[How to Find the Actual Price of the Discounted Price in Excel 365?](https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/)**
- **[Excel Formulas to Find Original Price from Percentage Discount!!](https://geekexcel.com/excel-formulas-to-find-original-price-from-percentage-discount/)**