Formulas > =TBILLPRICE()
How to Use TBILLPRICE() in Google Sheets
Description
How To Actually Use TBILLPRICE() in Sheets
TBILLPRICE(settlement, maturity, discount)
Try TBILLPRICE yourself
In cells A1 to A3, enter the settlement date, maturity date, and discount rate respectively. Use the TBILLPRICE formula in cell B1 to calculate the price of the Treasury Bill based on these inputs.
Hints (2)
-
Make sure the dates are in the correct format.
-
The discount rate should be a decimal (e.g., 0.05 for 5%).
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 BetterSheets.co/formulas
Learn more about the TBILLPRICE() formula:
Generate a TBILLPRICE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses TBILLPRICE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a TBILLPRICE() formula