Formulas > =T.INV.2T()

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


Calculates the inverse of the two-tailed TDIST function.

Common questions about the T.INV.2T formula:

1. What does the T.INV.2T formula do in Google Sheets?
2. How do I use the T.INV.2T formula?
3. What parameters does the T.INV.2T formula accept?

How can the T.INV.2T formula be used appropriately:

The T.INV.2T formula can be used to calculate two-tailed critical values of the Students' t-distribution. It requires two parameters: the alpha level (significance) and the degrees of freedom (df). The output of this function is the critical value of t-distribution for the given alpha level and df. 

How can the T.INV.2T formula be commonly mistyped:

The T.INV.2T formula can often be mistyped as T.INV2T or T.INV2.T.

What are some common ways the T.INV.2T formula is used inappropriately:

The T.INV.2T formula should not be used to calculate the inverse of a t-distribution. It can also not be used to calculate probabilities or p-values, as this function only outputs critical values.

What are some common pitfalls when using the T.INV.2T formula:

When using the T.INV.2T formula it is important to remember that it only produces two-tailed values and that the output of the formula is a critical value only. It is also important to make sure that the alpha level used is valid for the degrees of freedom.

What are common mistakes when using the T.INV.2T formula:

Common mistakes when using the T.INV.2T formula include mistyping the formula, using the wrong alpha level for the degrees of freedom, using the formula to output inverse distributions or probabilities, and using the wrong software or platform.

What are common misconceptions people might have with the T.INV.2T formula:

The most common misconception about the T.INV.2T formula is that it can be used to calculate probabilities or p-values. Another misconception is that it can be used to calculate inverse distributions.

How To Actually Use T.INV.2T() in Sheets

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

Generate a T.INV.2T() 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.


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.