T.INV function

Returns the left-tailed inverse of the Student's t-distribution.



The T.INV function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

  • Probability     Required. The probability associated with the Student's t-distribution.
  • Deg_freedom     Required. The number of degrees of freedom with which to characterize the distribution.


  • If either argument is nonnumeric, T.INV returns the #VALUE! error value.
  • If probability <= 0 or if probability > 1, T.INV returns the #NUM! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1, T.INV returns the #NUM! error value.
Applies to:
Excel 2010, Excel Web App