Alphabetical - T

TThe argument as a text string when the value is text.
T.DISTThe probability distribution function for a t distribution (left tailed).
T.DIST.2TThe probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RTThe probability distribution function for a t distribution (right tailed) (no cumulative).
T.INVThe inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2TThe inverse of the probability distribution function for a two tailed distribution.
T.TESTThe probability value from a t distribution.
TABLE(Data Tables, Not a Worksheet Function) The data table value calculated inside an array formula.
TAKE(2024) The intersection of specific rows and columns in an array.
TANThe tangent of an angle.
TANHThe hyperbolic tangent of a number.
TBILLEQThe yield (bond-equivalent) for a treasury bill.
TBILLPRICEThe price per $100 face value for a treasury bill.
TBILLYIELDThe yield for a treasury bill.
TDIST(T.DIST.2T) The percentage points probability for the t distribution.
TEXTThe number as a formatted text string.
TEXTAFTER(2024) The characters from the end of a text string after a delimiter.
TEXTBEFORE(2024) The characters from the start of a text string before a delimiter.
TEXTJOINThe text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT(2024) The text string split into multiple columns using delimiters.
TIMEThe time as a decimal given an hour, minute, second.
TIMEVALUEThe time as a decimal given a time in text format.
TINV(T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom.
TOCOL(2024) The array transformed into a single column.
TODAYThe date serial number representing today's date.
TOROW(2024) The array transformed into a single row.
TRANSLATE(365) The text string translated into another language.
TRANSPOSEThe array with its orientation changed.
TRENDThe y-values along a linear trend given a set of x-values.
TRIMThe text string with all extra spaces removed from the beginning, middle and end.
TRIMMEANThe mean of the interior of a data set.
TRIMRANGE(365) The array after excluding all empty rows and/or columns from the outer edges of a range.
TRUE(Compatibility) The logical value True.
TRUNCThe number truncated to a number of decimal places.
TTEST(T.TEST) The probability value from a t distribution.
TYPEThe number indicating the data type of the value.
T
The argument as a text string when the value is text.
T.DIST
The probability distribution function for a t distribution (left tailed).
T.DIST.2T
The probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RT
The probability distribution function for a t distribution (right tailed) (no cumulative).
T.INV
The inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2T
The inverse of the probability distribution function for a two tailed distribution.
T.TEST
The probability value from a t distribution.
TABLE
(Data Tables, Not a Worksheet Function) The data table value calculated inside an array formula.
TAKE
(2024) The intersection of specific rows and columns in an array.
TAN
The tangent of an angle.
TANH
The hyperbolic tangent of a number.
TBILLEQ
The yield (bond-equivalent) for a treasury bill.
TBILLPRICE
The price per $100 face value for a treasury bill.
TBILLYIELD
The yield for a treasury bill.
TDIST
(T.DIST.2T) The percentage points probability for the t distribution.
TEXT
The number as a formatted text string.
TEXTAFTER
(2024) The characters from the end of a text string after a delimiter.
TEXTBEFORE
(2024) The characters from the start of a text string before a delimiter.
TEXTJOIN
The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT
(2024) The text string split into multiple columns using delimiters.
TIME
The time as a decimal given an hour, minute, second.
TIMEVALUE
The time as a decimal given a time in text format.
TINV
(T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom.
TOCOL
(2024) The array transformed into a single column.
TODAY
The date serial number representing today's date.
TOROW
(2024) The array transformed into a single row.
TRANSLATE
(365) The text string translated into another language.
TRANSPOSE
The array with its orientation changed.
TREND
The y-values along a linear trend given a set of x-values.
TRIM
The text string with all extra spaces removed from the beginning, middle and end.
TRIMMEAN
The mean of the interior of a data set.
TRIMRANGE
(365) The array after excluding all empty rows and/or columns from the outer edges of a range.
TRUE
(Compatibility) The logical value True.
TRUNC
The number truncated to a number of decimal places.
TTEST
(T.TEST) The probability value from a t distribution.
TYPE
The number indicating the data type of the value.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top