TDIST

Microsoft publishes =TDIST(A2,A3,2) with the description "Two-tailed distribution (0.054644930, or 5.46 percent)" and a Result cell formatted as "5.46%". The assertable figure is the number, 0.054644930; the percent string is cell formatting. DERIVED on the doubly-cross-checked t CDF (incomplete beta AND numerical quadrature of the density, agreeing to 25 digits, with scipy as a third check): 2*(1 - F(1.959999998)) at 60 degrees of freedom = 0.05464492997592087239699, which is 0.054644930 at the published precision -- 0.05464493 as a number, the trailing zero being Microsoft's formatting. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/tdist-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror.

Microsoft publishes =TDIST(A2,A3,1) with the description "One-tailed distribution (0.027322465 or 2.73 percent)". Derived as 1 - F(1.959999998) at 60 degrees of freedom = 0.02732246498796043619849, i.e. 0.027322465 at the published precision -- exactly half the two-tailed row above, which the page's own definitions require.

The TDIST page's Important box directs readers to "T.DIST.2T function and T.DIST.RT function", and its Remarks define TDIST with tails = 2 as P(|X| > x) -- exactly what T.DIST.2T computes. A structural assertion with no derived constant, checking the engine's legacy and modern spellings against each other. THIS IS THE CASE THAT WOULD CATCH A COMPATIBILITY-FUNCTION ALIAS THAT DRIFTED, which is the whole reason the legacy names are still in this corpus.

TDIST with tails = 1 is defined on the page as P(X > x), which is T.DIST.RT. A structural assertion with no derived constant.

The Remarks publish: "If x < 0, then TDIST returns the #NUM! error value." The same page ALSO publishes, two bullets later, the identities "TDIST(-x,df,1) = 1 - TDIST(x,df,1) = P(X > -x)" and "TDIST(-x,df,2) = TDIST(x,df,2) = P(|X| > x)" -- i.e. it defines the function at negative arguments in the same breath as forbidding them. Recorded as published; the #NUM! rule is the one asserted, because it is the one stated as a return value.

The Remarks publish: "If tails is any value other than 1 or 2, TDIST returns the #NUM! error value."

The Remarks publish: "If deg_freedom < 1, TDIST returns the #NUM! error value." Note this legacy page NAMES the code where its modern sibling T.DIST does not.

Microsoft publishes =TDIST(A2,A3,2) with the description "Two-tailed distribution (0.054644930, or 5.46 percent)" and a Result cell formatted as "5.46%". The assertable figure is the number, 0.054644930; the percent string is cell formatting. DERIVED on the doubly-cross-checked t CDF (incomplete beta AND numerical quadrature of the density, agreeing to 25 digits, with scipy as a third check): 2*(1 - F(1.959999998)) at 60 degrees of freedom = 0.05464492997592087239699, which is 0.054644930 at the published precision -- 0.05464493 as a number, the trailing zero being Microsoft's formatting. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/tdist-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror.

Microsoft publishes =TDIST(A2,A3,1) with the description "One-tailed distribution (0.027322465 or 2.73 percent)". Derived as 1 - F(1.959999998) at 60 degrees of freedom = 0.02732246498796043619849, i.e. 0.027322465 at the published precision -- exactly half the two-tailed row above, which the page's own definitions require.

The TDIST page's Important box directs readers to "T.DIST.2T function and T.DIST.RT function", and its Remarks define TDIST with tails = 2 as P(|X| > x) -- exactly what T.DIST.2T computes. A structural assertion with no derived constant, checking the engine's legacy and modern spellings against each other. THIS IS THE CASE THAT WOULD CATCH A COMPATIBILITY-FUNCTION ALIAS THAT DRIFTED, which is the whole reason the legacy names are still in this corpus.

TDIST with tails = 1 is defined on the page as P(X > x), which is T.DIST.RT. A structural assertion with no derived constant.

The Remarks publish: "If x < 0, then TDIST returns the #NUM! error value." The same page ALSO publishes, two bullets later, the identities "TDIST(-x,df,1) = 1 - TDIST(x,df,1) = P(X > -x)" and "TDIST(-x,df,2) = TDIST(x,df,2) = P(|X| > x)" -- i.e. it defines the function at negative arguments in the same breath as forbidding them. Recorded as published; the #NUM! rule is the one asserted, because it is the one stated as a return value.

The Remarks publish: "If tails is any value other than 1 or 2, TDIST returns the #NUM! error value."

The Remarks publish: "If deg_freedom < 1, TDIST returns the #NUM! error value." Note this legacy page NAMES the code where its modern sibling T.DIST does not.

Microsoft publishes =TDIST(A2,A3,2) with the description "Two-tailed distribution (0.054644930, or 5.46 percent)" and a Result cell formatted as "5.46%". The assertable figure is the number, 0.054644930; the percent string is cell formatting. DERIVED on the doubly-cross-checked t CDF (incomplete beta AND numerical quadrature of the density, agreeing to 25 digits, with scipy as a third check): 2*(1 - F(1.959999998)) at 60 degrees of freedom = 0.05464492997592087239699, which is 0.054644930 at the published precision -- 0.05464493 as a number, the trailing zero being Microsoft's formatting. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/tdist-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror.

Microsoft publishes =TDIST(A2,A3,1) with the description "One-tailed distribution (0.027322465 or 2.73 percent)". Derived as 1 - F(1.959999998) at 60 degrees of freedom = 0.02732246498796043619849, i.e. 0.027322465 at the published precision -- exactly half the two-tailed row above, which the page's own definitions require.

The TDIST page's Important box directs readers to "T.DIST.2T function and T.DIST.RT function", and its Remarks define TDIST with tails = 2 as P(|X| > x) -- exactly what T.DIST.2T computes. A structural assertion with no derived constant, checking the engine's legacy and modern spellings against each other. THIS IS THE CASE THAT WOULD CATCH A COMPATIBILITY-FUNCTION ALIAS THAT DRIFTED, which is the whole reason the legacy names are still in this corpus.

TDIST with tails = 1 is defined on the page as P(X > x), which is T.DIST.RT. A structural assertion with no derived constant.

The Remarks publish: "If x < 0, then TDIST returns the #NUM! error value." The same page ALSO publishes, two bullets later, the identities "TDIST(-x,df,1) = 1 - TDIST(x,df,1) = P(X > -x)" and "TDIST(-x,df,2) = TDIST(x,df,2) = P(|X| > x)" -- i.e. it defines the function at negative arguments in the same breath as forbidding them. Recorded as published; the #NUM! rule is the one asserted, because it is the one stated as a return value.

The Remarks publish: "If tails is any value other than 1 or 2, TDIST returns the #NUM! error value."

The Remarks publish: "If deg_freedom < 1, TDIST returns the #NUM! error value." Note this legacy page NAMES the code where its modern sibling T.DIST does not.