=TINV() ☆

⬇ Download Sample Workbook

A dedicated .xlsx for =TINV() with Persian sample data & live formulas — open in Excel and practice.

• Sheet “Sample” — data table + formula in place
• Sheet “Guide” — syntax, arguments & tips from this page
• Instant & secure (token + rate limit)

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

▣ Examples

§ Remarks

• If either argument is nonnumeric, TINV returns the #VALUE! error value.
• If probability <= 0 or if probability > 1, TINV returns the #NUM! error value.
• If deg_freedom is not an integer, it is truncated.
• If deg_freedom < 1, TINV returns the #NUM! error value.
• TINV returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).
• A one-tailed t-value can be returned by replacing probability with 2*probability. For a probability of 0.05 and degrees of freedom of 10, the two-tailed value is calculated with TINV(0.05,10), which returns 2.28139. The one-tailed value for the same probability and degrees of freedom can be calculated with TINV(2*0.05,10), which returns 1.812462. Note In some tables, probability is described as (1-p). Given a value for probability, TINV seeks that value x such that TDIST(x, deg_freedom, 2) = probability. Thus, precision of TINV depends on precision of TDIST. TINV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.

✦ Tips

• This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new functions, see T.INV.2T function or T.INV function.
• If deg_freedom is not an integer, it is truncated.
• TINV returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).

⚠ Common Errors

⇄ Related Functions

Share your thoughts — visible after admin approval

✍️ Add comment / question

Comment Question Answer ✕

Name * Email (optional)

Message * 10–1000

Security code *

↻ New image

📩 Submit — will appear after approval

🔒 Your comment will be published after review.