Formulas > =T.INV.2T()

How to Use T.INV.2T() in Google Sheets

Description

Calculates the inverse of the two-tailed TDIST function.

How To Actually Use T.INV.2T() in Sheets

T.INV.2T(probability, degrees_freedom)

Try T.INV.2T yourself

In cells A1 and A2, enter the probability and degrees of freedom respectively. Use the T.INV.2T formula in cell B1 to calculate the two-tailed t-value based on these inputs.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for T.INV.2T(). Click through to watch.

Watch more tutorials
Embed a Number in a Website from a Google Sheet

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Learn more about the T.INV.2T() formula:

Generate a T.INV.2T() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses T.INV.2T(). 2 free AI generations, no signup. Members get unlimited use.

Generate a T.INV.2T() formula
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.