Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| T | Returns the text referred to by a value. | Use the TEXT function to convert a numeric value to text. |
| TAN | Returns the tangent of an angle. | There is no equivalent Anaplan function, but can be built using a calculation. |
| TANH | Returns the hyperbolic tangent of a number. | There is no equivalent Anaplan function, but can be built using a calculation. |
| TEXT | Returns a value converted to text with a specified format. | Use the TEXT function to convert a numeric value to text. |
| TEXTJOIN | Used to join two or more strings together, separated by a delimiter. | Use the & operator to concatenate two or more text strings. |
| TIME | Returns a decimal number given an hour, minute, and second value. | There is no equivalent Anaplan function, but can be built using a calculation. |
| TIMEVALUE | Returns the serial number of a time. | There is no equivalent Anaplan function, but can be built using a calculation. |
| TODAY | Returns the current system date. | There is no equivalent Anaplan function, but the date can be imported. |
| TRANSPOSE | Returns a transposed range of cells. | Create a module with a pivoted view. |
| TRIM | Returns a text value with the leading and trailing spaces removed. | Use the TRIM function. |
| TRUE | Returns a logical value of TRUE. | Use a boolean argument. |
| TRUNC | Returns a number truncated to a specified number of digits. | Use the module formatting functionality. |
| TYPE | Returns the value's type. | There is no equivalent Anaplan function. |
