# TBILLEQ

TBILLEQ(settlement, maturity, discount)

Returns the yield (bond-equivalent) for a treasury bill.

 settlement The settlement date of the treasury bill. maturity The maturity date of the treasury bill. discount The discount rate of the treasury bill.

 REMARKS
 * This function calculates the bond equivalent yield for a treasury bill.* The "settlement" is the date after the issue date when the treasury bill is traded to the buyer.* The "maturity" is the date when the treasury bill expires.* Dates must be entered as text strings within quotation marks or as serial numbers.* If "settlement" is not an integer, it is truncated.* If "settlement" is not a valid date, then #NUM! is returned.* If "settlement" > "maturity" , then #NUM! is returned.* If "maturity" is more than one year after "settlement", then #NUM! is returned.* If "maturity" is not an integer, it is truncated.* If "maturity" is not a valid date, then #NUM! is returned.* If "discount" = 0, then #NUM! is returned.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =TBILLEQ("3/10/1999", "6/1/2000", 9.5/100) = 0.099 2 =TBILLEQ("3/10/1999", "6/1/2000", 50/100) = 0.584 3 =TBILLEQ("3/10/1999", "6/1/2000", -2) = #NUM! 4 =TBILLEQ("3/10/1999", "6/1/2000", "some text") = #VALUE!