Alphabetical - T

TThe text string of the value given.
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.
TAKE(Microsoft 365) The intersection of specific rows and columns in an array.
TANThe tangent of a number.
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(Microsoft 365) The characters from the end of a text string after a delimiter.
TEXTBEFORE(Microsoft 365) The characters from the start of a text string before a delimiter.
TEXTJOIN(2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT(Microsoft 365) 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(Microsoft 365) The array transformed into a single column.
TODAYThe date serial number representing today's date.
TOROW(Microsoft 365) The array transformed into a single row.
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.
TRUEThe logical value True.
TRUNCThe number with any decimal places removed.
TTEST(T.TEST) The probability value from a t distribution.
TYPEThe number indicating the data type of the value.
T
The text string of the value given.
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.
TAKE
(Microsoft 365) The intersection of specific rows and columns in an array.
TAN
The tangent of a number.
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
(Microsoft 365) The characters from the end of a text string after a delimiter.
TEXTBEFORE
(Microsoft 365) The characters from the start of a text string before a delimiter.
TEXTJOIN
(2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT
(Microsoft 365) 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
(Microsoft 365) The array transformed into a single column.
TODAY
The date serial number representing today's date.
TOROW
(Microsoft 365) The array transformed into a single row.
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.
TRUE
The logical value True.
TRUNC
The number with any decimal places removed.
TTEST
(T.TEST) The probability value from a t distribution.
TYPE
The number indicating the data type of the value.

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