Functions
TBILLYIELD
T-bill yield
Try it
When to use it
When should I use TBILLYIELD?
Use TBILLYIELD to compute the yield of a Treasury bill from its purchase price — useful when evaluating whether a T-bill available at a given market price meets a target return.
Used in
Syntax
TBILLYIELD(settlement, maturity, pr)Examples
=TBILLYIELD(DATE(2010,1,2),DATE(2010,12,31),98.45) // => 0.015613916532703153