Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| IF | Returns one value if the condition is TRUE, or another value if the condition is FALSE. | Use an IF THEN ELSE conditional formula. |
| IF (more than 7) | Nest more than seven IF functions. | Use an IF THEN ELSE conditional formula. |
| IF (up to 7) | Nest up to seven IF functions. | Use an IF THEN ELSE conditional formula. |
| IFERROR | Used to return an alternate value if a formula results in an error. | Use an IF THEN ELSE conditional formula. |
| IFNA | Used to return an alternate value if a formula results in #N/A error. | Use an IF THEN ELSE conditional formula. |
| IFS | Specify multiple IF conditions within a function. | Use an IF THEN ELSE conditional formula. |
| INDEX | Returns either the value or the reference to a value from a table or range. | Use the FINDITEM formula to match text to an item in a list, or in a time period list. Matches can be on the item name or code. |
| INDIRECT | Returns the reference to a cell based on its string representation. | Use the LOOKUP and TEXT formulas. |
| INFO | Returns information about the operating environment. | There is no equivalent Anaplan function, but can be built using a calculation. |
| INT | Returns the integer part of a number. | Use module formatting. |
| INTERCEPT | Returns the y-axis intersection point of a line using x-axis values and y-axis values. | There is no equivalent Anaplan function, but can be built using a calculation. |
| IPMT | Returns the interest payment for an investment. | Use the RATE formula to calculate a per period interest rate. |
| IRR | Returns the internal rate of return for a series of cash flows. | Use the IRR function. |
| ISBLANK | Checks for blank or null values. | Use the ISBLANK function. |
| ISERR | Checks for error values except #N/A. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISERROR | Checks for error values. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISLOGICAL | Checks for a logical value (TRUE or FALSE). | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISNA | Checks for #N/A error values. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISNONTEXT | Checks for a value that is not text. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISNUMBER | Checks for a numeric value. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISOWEEKNUM | Returns the ISO week number for a date. | There is no equivalent Anaplan function. Use the internal time structure in Anaplan. |
| ISPMT | Returns the interest payment for an investment. | Use the RATE function to calculate a per period interest rate. |
| ISREF | Checks for a reference. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ISTEXT | Checks for a text value. | There is no equivalent Anaplan function, but can be built using a calculation. |
