How to use the TBILLPRICE function in Excel Office 365?
Tags: tousethetbillpricefu, excel, excelfunctions
Published: 2021-08-25 02:36:12

---
title: How to use the TBILLPRICE function in Excel Office 365?
published: true
date: 2021-08-20 13:49:57 UTC
tags: ToUseTheTBILLPRICEFu,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-tbillprice-function-in-excel-office-365/
---

 **TBILLPRICE function** returns the **price per $100 face value** for a Treasury bill, and it takes the **settlement date and maturity date as argument dates** along with the **discount rate**. In this article, we are going to see how to  **use the TBILLPRICE Function In Excel Office 365**. 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)**

## TBILLPRICE function syntax

```
=TBILLPRICE (settlement, maturity, discount)
```

**Syntax Explanation:**

- **settlement** : settlement date of bill.
- **maturity** : maturity date of bill.
- **discount** : discount rate on bill.

## Example

- Firstly, you have to **create a data** with **settlement date, maturity date** and **discount rate** for the treasury bill.

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

- Then, you need to calculate the **TBILLPRICE function** by using the below given **formula**.

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

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

- Now, you have to calculate the **PRICE function** by using the same formula.

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

**Check this too:** [How to use the BINOM.DIST function in Excel Office 365?](https://geekexcel.com/how-to-use-the-binom-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:
  - If maturity date settlement value.
  - If discount rate argument is < 0

## Wrap-Up

Hope you understood how to  **use the TBILLPRICE Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[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/)**
- **[Formulas to Lookup a Latest Price ~ A Complete Tutorial!!](https://geekexcel.com/lookup-a-latest-price-excel-formula/)**
- **[Excel Formulas to Calculate the Interest Rate for Loan ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-rate-for-loan/)**