[]

Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
  - ACCRINT
  - ACCRINTM
  - AMORDEGRC
  - AMORLINC
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - CUMIPMT
  - CUMPRINC
  - DB
  - DDB
  - DISC
  - DOLLARDE
  - DOLLARFR
  - DURATION
  - EFFECT
  - FV
  - FVSCHEDULE
  - INTRATE
  - IPMT
  - IRR
  - ISPMT
  - MDURATION
  - MIRR
  - NOMINAL
  - NPER
  - NPV
  - ODDFPRICE
  - ODDFYIELD
  - ODDLPRICE
  - ODDLYIELD
  - PDURATION
  - PMT
  - PPMT
  - PRICE
  - PRICEDISC
  - PRICEMAT
  - PV
  - RATE
  - RECEIVED
  - RRI
  - SLN
  - SYD
  - TBILLEQ
  - TBILLPRICE
  - TBILLYIELD
  - VDB
  - XIRR
  - XNPV
  - YIELD
  - YIELDDISC
  - YIELDMAT
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

TBILLYIELD

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