[]

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

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	Settlement date for the Treasury bill
mature	Maturity date for the Treasury bill
discount	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.

Data Types

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

Examples

TBILLPRICE(A1,B2,C3)

TBILLPRICE("3/31/2003","6/1/2003",0.065) gives the result $98.88055556