- 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
TBILLPRICE
This function returns the price per $100 face value for a Treasury bill (or T-bill).
Syntax
TBILLPRICE(settle, mature, discount)
Arguments
This function has these arguments:
Argument | Description |
|---|---|
settle | [Required] Settlement date for the Treasury bill |
mature | [Required] Maturity date for the Treasury bill |
discount | [Required] Discount rate 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 discount is less than or equal to 0, a #NUM! error is returned.
If settle is greater than mature or if mature is more than one year after settle, a #NUM! error is returned.
Examples
TBILLPRICE(A1,B2,C3)
TBILLPRICE("3/31/2003","6/1/2003",0.065) gives the result 98.88055556