TBILLPRICE

Definition: The TBILLPRICE function in Excel is used to calculate the price per $100 face value of a US Treasury bill.

Syntax: ==TBILLPRICE(settlement, maturity, discount).

Situation: This formula is appropriate in situations where you need to calculate the price per $100 face value of a US Treasury bill.

Example: If the settlement date is January 1, 2020, the maturity date is June 30, 2020, and the discount rate is 0.5%, you would use the formula =TBILLPRICE(“1/1/2020”, “6/30/2020”, 0.5%). This would return a value that indicates the price per $100 face value.