Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| EDATE | Adds 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. |
| EOMONTH | Calculates the last day of the month after adding a specified number of months to a date. | Use the END function. |
| ERROR.TYPE | Returns the numeric representation of an Excel error. | There's no equivalent Anaplan function, but can be built using a calculation. |
| EVEN | Rounds a number up to the nearest even integer. | There's no equivalent Anaplan function, but can be built using a calculation. |
| EXACT | Compares 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. |
| EXP | Returns e raised to the nth power. | Use the EXP function. |
