Comparisons of Microsoft Excel functions to those available in Anaplan.

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

 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.