Formulas > =TBILLYIELD()

How To Use TBILLYIELD() Function in Google Sheets


Calculates the yield of a US Treasury Bill based on price.

Common questions about the TBILLYIELD Formula:
1. What is the TBILLYIELD Formula?
2. How does the TBILLYIELD Formula calculate yields?
3. What parameters does the TBILLYIELD Formula require?

How to use the TBILLYIELD Formula appropriately:
1. Input the amount and maturity date of the security to calculate the yield
2. Enter the quotation frequency
3. Ensure the value chosen for the redemption frequency is consistent
4. Specify whether the bond is for a zero coupon bond or coupon bond

How to commonly mistype the TBILLYIELD Formula:
1. Not specifying quotation frequency
2. Not specifying maturity date
3. Entering incorrect redemption frequency
4. Also, some misspellings like TBLLYIELD, TBILLYEILD, TBILLYILD, TBILYIELD.

Common ways of using the TBILLYIELD Formula inappropriately:
1. Attempting to calculate the yield without entering the appropriate parameters
2. Entering non-numeric values
3. Not setting the right quotation frequency

Common pitfalls when using the TBILLYIELD Formula:
1. Not entering the appropriate parameters
2. Inputting incorrect maturity date or quotation frequency
3. Inputting incorrect redemption frequency

Common mistakes when using the TBILLYIELD Formula:
1. Not using the correct maturity date
2. Not entering the correct quotation frequency
3. Not entering the right redemption frequency

Common misconceptions people might have with the TBILLYIELD Formula:
1. Believing that the TBILLYIELD Formula is a long-term yield calculation 
2. Thinking that the TBILLYIELD Formula is a cash flow analysis 
3. Confusing the TBILLYIELD Formula with the YIELD function

How To Actually Use TBILLYIELD() in Sheets

TBILLYIELD(settlement, maturity, price)

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 TBILLYIELD() formula:

How to use TBILLYIELD function in Excel

The TBILLYIELD function in Microsoft® Excel is used to calculate the yield of a Treasury Bill. Use the TBILLYIELD function in Microsoft® Excel by following the steps shown in this video.

Generate a TBILLYIELD() 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.