# Alphabetical - T

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. |

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. |

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