1. Calculation functions
  2. Functions
  3. Excel comparison
  4. Excel comparison: E 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
EDATEAdds a specified number of months to a date and returns the result as a serial date.Use the OFFSET function to return a value from a specified number of periods in advance.
EOMONTHCalculates the last day of the month after adding a specified number of months to a date.Use the END function.
ERROR.TYPEReturns the numeric representation of an Excel error.There's no equivalent Anaplan function, but can be built using a calculation.
EVENRounds a number up to the nearest even integer.There's no equivalent Anaplan function, but can be built using a calculation.
EXACTCompares two strings and returns TRUE if both values are the same.Use the COMPARE function to compare text values. The result is 0 if they match, 1 or -1 if not matched.
EXPReturns e raised to the nth power.Use the EXP 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.