Formulas > =TBILLEQ()

How To Use TBILLEQ() Function in Google Sheets


Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

Common questions about the TBILLEQ formula include:
1. What does the TBILLEQ formula do?
2. How do you use the TBILLEQ formula?
3. What is an example of the TBILLEQ formula?

The TBILLEQ formula is used for calculating the true cost of a loan or bond, or the true yield of a loan or bond, by taking into account both the stated nominal rate and the periodic compounding of interest. Appropriate use of the formula requires entering the appropriate values correctly into each component.

The TBILLEQ formula can be commonly mistyped as TBILEQ, TBILLQE, TBLLEQ or also due to its complex components. A typographical error such as spelling the formula incorrectly, incorrectly using variables, or not including parenthesis or other symbols, can render the formula inoperable.

Common ways the TBILLEQ formula is used inappropriately include incorrect data types input such as entering numbers as text or entering text where a number is expected. Another use of the formula that produces inaccuracies is entering a period frequency such as Daily or Weekly without having the daily or weekly earning calculations taken into account.

Common pitfalls when using the TBILLEQ formula include forgetting to enter the formula in the conventional form, which may lead to a calculation error. In addition, not providing all of the necessary components will render the formula as numerical errors or #VALUE! results.

Common mistakes when using the TBILLEQ Formula include forgetting or incorrectly entering important components such as values, functions and operators. It is also important to check the results of the formula to make sure it is producing the expected and correct results.

Common misconceptions people might have with the TBILLEQ Formula include not understanding how to use the formula correctly, believing they can calculate the effective yield of a loan or bond without using the formula, or believing the results of the formula are wrong.

How To Actually Use TBILLEQ() in Sheets

TBILLEQ(settlement, maturity, discount)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the TBILLEQ() formula:

TBILLEQ function in Excel

The TBILLEQ function in Microsoft® Excel is used to calculate the bond-equivalent yield for a Treasury Bill. Follow the steps given in this video to use the TBILLEQ function in Microsoft® Excel.

Generate a TBILLEQ() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.