TBILLPRICE
TheTBILLPRICE
formula calculates the price per $100 face value of a US Treasury bill. This formula is most commonly used by investors to determine the fair value of a Treasury bill before buying or selling it on the secondary market.
 How to use
TBILLPRICE
formula?  Examples of using
TBILLPRICE
formula TBILLPRICE
formula not working? Similar formulas to
TBILLPRICE
Usage
Use the TBILLPRICE
formula with the syntax shown below, it has 3 required parameters:
 settlement (required):
The date on which the Treasury bill is purchased.  maturity (required):
The date on which the Treasury bill matures.  discount (required):
The discount rate of the Treasury bill.
Examples
Here are a few example use cases that explain how to use theTBILLPRICE
formula in Google Sheets.
Determining the price of a Treasury bill
Investors can use the TBILLPRICE
formula to calculate the price of a Treasury bill before buying or selling it on the secondary market.
Calculating the yield of a Treasury bill
By using the TBILLPRICE
formula in conjunction with the TBILLYIELD
formula, investors can calculate the yield of a Treasury bill.
Comparing Treasury bills of different maturities
Investors can use the TBILLPRICE
formula to compare the fair values of Treasury bills with different maturities to determine which one offers the best value.
Common Mistakes
TBILLPRICE
not working? Here are some common mistakes people make when using the TBILLPRICE
Google Sheets Formula:
Using incorrect date formats
Make sure to use the correct date format for the settlement
and maturity
parameters. Dates should be entered as either a serial number or a date enclosed in quotation marks.
Using incorrect discount rate
Make sure to use the correct discount rate for the Treasury bill being analyzed. The discount rate should be entered as a decimal, not a percentage.
Related Formulas
The following functions are similar to TBILLPRICE
or are often used with it in a formula:

TBILLYIELD
The
TBILLYIELD
function calculates the yield of a Treasury bill based on its price. It returns the annual yield of a Treasury bill (a type of shortterm government security), based on its price, maturity, and settlement dates. This function is commonly used in financial analysis to compare the yield of Treasury bills with other types of investments. 
TREND
The
TREND
formula is used to calculate future values based on historical data. It fits a straight line (using the method of least squares) to the arrays specified in theknown_data_y
andknown_data_x
parameters and then uses that line to calculate new yvalues for the array specified in thenew_data_x
parameter. Ifb
is set to TRUE, then the calculation will include the yintercept of the line. This formula is commonly used in forecasting and trend analysis. 
PV
The
PV
function in Google Sheets calculates the present value of a regular payment stream or a lump sum amount, based on a constant interest rate. It is commonly used in financial analysis to determine the value of investments or loans. This function returns a negative value, as it represents money flowing out from the user. 
FV
The
FV
function calculates the future value of an investment based on periodic constant payments and a constant interest rate. It takes into account the present value of the investment, the number of periods in which the payments are made, and the compounding frequency. This formula is commonly used in financial planning and investment analysis.
Learn More
You can learn more about the TBILLPRICE
Google Sheets function on Google Support.