Formulas > =T.INV()

How To Use T.INV() Function in Google Sheets


Calculates the negative inverse of the one-tailed TDIST function.

Common questions about the T.INV formula include: what is it used for, what are its arguments, how do you format it, and how can it be applied to specific data sets?

T.INV can be used appropriately to calculate a value of a t statistic at a given tail area probability (alpha) and degrees of freedom. Often, this is used for significance testing, a type of predictive analysis.

The T.INV formula can be commonly mistyped as T.IN if the lowercase “v” is omitted. 

Some common ways the T.INV formula is used inappropriately include passing in incorrect arguments, mixing up the arguments for the tail area probability and degrees of freedom, or incorrectly assuming that the output of the formula represents a probability.

Common pitfalls when using the T.INV formula include not understanding the concept of signal-to-noise ratio, and not accounting for the underlying distribution of the data.

Common mistakes when using the T.INV Formula include forgetting to lock in cell references and not accounting for distributions other than the normal distribution.

Common misconceptions people might have with the T.INV Formula include that a big t statistic implies the null hypothesis is true, or that it is used to calculate p values or confidence intervals."

How To Actually Use T.INV() in Sheets

T.INV(probability, degrees_freedom)

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 T.INV() formula:

Generate a T.INV() 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. Free to try for non-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.