The T.DIST.2T function returns the two-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The T.DIST.2T function, along with the T.DIST.RT function, replace the TDIST function included in earlier versions of Excel.




Argument Description
x The value at which you want to evaluate the distribution
deg_freedom An integer indicating the number of degrees of freedom – must be ≥ 1


  A B C D
1 Data Description    
2 1.856954 Value at which to evaluate the distribution    
3 40 Degrees of freedom    
5 Formula Result Notes
6 =T.DIST.2T(A2,A3) 7.07% Two-tailed distribution (0.070692 or 7.07%)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either of the supplied arguments are non-numeric
#NUM! Occurs if either:

  the supplied x argument is < 0
  the supplied deg_freedom argument is < 1