Skip to main content


Definition of T.INV:

This formula calculates the negative inverse of the one-tailed TDIST function.

Sample Usage

T.INV(0.35, 1)

T.INV(A1, A2)


Syntax for T.INV: 

  • T.INV(probability, degrees_freedom)
    • probability - The probability associated with the 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 is to be used for the negative inverse of the one-tailed TDIST function.
  • Both arguments to T.INV 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).

T.INV.2T: Calculates the inverse of the two-tailed TDIST function.

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

Step 1. To use the T.INV Formula, start with the Excellentable you would like to edit.

Step 2. Then type the T.INV formula into the cell you have chosen to display the outcome:

Step 3. Fill in the 2 values- In this example I have chosen 2 values that are the same. 

Step 4. Once saved, your completed formula will display in a confluence page like this. 


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.