Skip to main content



Calculates the inverse of the two-tailed TDIST function.

Sample Usage

T.INV.2T(0.35, 1)

T.INV.2T(A1, A2)


T.INV.2T(probability, degrees_freedom)

  • probability - The probability associated with the two-tailed t-distribution.

    • Must be greater than 0 and less than 1.

  • degrees_freedom - The number of degrees of freedom.

    • Truncated to an integer in the calculation if a non-integer is provided as an argument.

    • Must be greater than or equal to 1.


  • T.INV.2T is to be used for the inverse of two-tailed TDIST functions.

  • T.INV.2T is synonymous with TINV.

  • To calculate the negative inverse of the one-tailed TDIST function, use T.INV.

  • Both arguments to T.INV.2T must be numeric or a destination cell whose value is numeric.

See Also

TDIST: Calculates the probability for Student's t-distribution with a given input (x).

TINV: Calculates the inverse of the two-tailed TDIST function.

T.INV: Calculates the negative inverse of the one-tailed TDIST function.


In this example, T.INV.2T uses the probability associated with a Student's two-tailed t-distribution and degrees of freedom to return its result.

In order to use the T.INV.2T formula, start with your edited Excellentable:

Then type in the T.INV.2T Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the T.INV.2T formula for, Excellentable will generate the outcome:



User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.