# TBILLYIELD

## Content

This function returns the yield for a Treasury bill (or T-bill).

## Syntax

`TBILLYIELD(settle, mature, priceper)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *settle* | [Required] Settlement date for the Treasury bill |
| *mature* | [Required] Maturity date for the Treasury bill |
| *priceper* | [Required] Price per $100 face value for the Treasury bill |

## Remarks

This function returns a #VALUE! error when *settle* or *mature* is invalid. *Settle* and *mature* are truncated to integers.
The function returns an error in the following cases:

* If *priceper* is less than or equal to 0, a #NUM! error is returned.
* If *settle* is greater than or equal to *mature* or if *mature* is more than one year after *settle*, a #NUM! error is returned.

## Examples

`TBILLYIELD(A1,B2,C3)`
`TBILLYIELD("3/31/2003","6/1/2003",98.65)` gives the result 0.0794598041299475