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. |