1. Calculation functions
  2. Functions
  3. Excel comparison
  4. Excel comparison: T functions

Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.

A B C D E F G H I L M N O P Q R S T U V W X Y

Excel functionExcel descriptionAnaplan solution
TReturns the text referred to by a value.Use the TEXT function to convert a numeric value to text.
TANReturns the tangent of an angle.There is no equivalent Anaplan function, but can be built using a calculation.
TANHReturns the hyperbolic tangent of a number.There is no equivalent Anaplan function, but can be built using a calculation.
TEXTReturns a value converted to text with a specified format.Use the TEXT function to convert a numeric value to text.
TEXTJOINUsed to join two or more strings together, separated by a delimiter.Use the & operator to concatenate two or more text strings.
TIMEReturns a decimal number given an hour, minute, and second value.There is no equivalent Anaplan function, but can be built using a calculation.
TIMEVALUEReturns the serial number of a time.There is no equivalent Anaplan function, but can be built using a calculation.
TODAYReturns the current system date.There is no equivalent Anaplan function, but the date can be imported.
TRANSPOSEReturns a transposed range of cells.Create a module with a pivoted view.
TRIMReturns a text value with the leading and trailing spaces removed.Use the TRIM function.
TRUEReturns a logical value of TRUE.Use a boolean argument.
TRUNCReturns a number truncated to a specified number of digits.Use the module formatting functionality.
TYPEReturns the value's type.There is no equivalent Anaplan function.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.