Functions
TBILLPRICE
T-bill price
Try it
When to use it
When should I use TBILLPRICE?
Use TBILLPRICE to find the price per $100 face value of a Treasury bill given its discount rate — useful for determining how much to pay for a T-bill in the secondary market.
Used in
Syntax
TBILLPRICE(settlement, maturity, discount)Examples
=TBILLPRICE(DATE(2010,1,2),DATE(2010,12,31),0.0125) // => 98.73958333333334