Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| T.INV.2T | Statistical |
 |
Returns the inverse of the Student's t-distribution |
| T.TEST | Statistical |
|
Returns the probability associated with a Student's t-test |
| TAN | Math and trigonometry |
|
Returns the tangent of a number |
| TANH | Math and trigonometry |
|
Returns the hyperbolic tangent of a number |
| TBILLEQ | Financial |
|
Returns the bond-equivalent yield for a Treasury bill |
| TBILLPRICE | Financial |
|
Returns the price per $100 face value for a Treasury bill |
| TBILLYIELD | Financial |
|
Returns the yield for a Treasury bill |
| TDIST | Compatibility |
|
Returns the Student's t-distribution |
| TEXT | Text |
|
Formats a number and converts it to text |
| TEXTJOIN | Text |
|
Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. |
| TIME | Date and time |
|
Returns the serial number of a particular time |
| TIMEVALUE | Date and time |
|
Converts a time in the form of text to a serial number |
| TINV | Compatibility |
|
Returns the inverse of the Student's t-distribution |
| TODAY | Date and time |
|
Returns the serial number of today's date |
| TRANSPOSE | Lookup and reference |
|
Returns the transpose of an array |
| TREND | Statistical |
|
Returns values along a linear trend |
| TRIM | Text |
|
Removes spaces from text |
| TRIMMEAN | Statistical |
|
Returns the mean of the interior of a data set |
| TRUE | Logical |
|
Returns the logical value TRUE |
| TRUNC | Math and trigonometry |
|
Truncates a number to an integer |