How to use TBILLPRICE in Google Sheets

Product Solutions Templates Resources Pricing

TBILLPRICE

Calculates the price of a US Treasury Bill based on discount rate. Learn more

Financial

TBILLPRICE is a financial function in Google Sheets that calculates the price of a Treasury bill (T-bill) based on its settlement date, maturity date, and discount rate.

The function takes three arguments:

settlement: The date on which the T-bill is purchased. maturity: The date on which the T-bill matures. discount: The discount rate of the T-bill.

The output of the TBILLPRICE function is the price per $100 face value of the T-bill, which is a measure of how much the T-bill is worth at the time of purchase.

Visit Official Docs

Want even more from Google Sheets?

With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.

Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.

Try Softr now and build your custom web apps in 10 minutes – no code required!

Try Softr for Free