Alphabetical - T

TThe text string of the value given.
T.DISTThe probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2TThe percentage points probability for the t distribution.
T.DIST.RTThe probability of getting greater than a particular value in a t distribution (right tailed).
T.INVThe probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2TThe t value of the t distribution as a function of the probability and the degrees of freedom.
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 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 of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T
The percentage points probability for the t distribution.
T.DIST.RT
The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV
The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T
The t value of the t distribution as a function of the probability and the degrees of freedom.
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 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.

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