[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode 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 Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
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	Settlement date for the Treasury bill
mature	Maturity date for the Treasury bill
priceper	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.

Data Types

Accepts numeric and DateTime object data for all arguments. Returns numeric data.

Examples

TBILLYIELD(A1,B2,C3)

TBILLYIELD("3/31/2003","6/1/2003",98.65) gives the result 0.0794598041299475 (or 5.80%)