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!