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 ABS Returns the absolute value of a number. Use the ABS function. ACCRINT Returns the accrued interest for a security that pays interest on a periodic basis. See the Financial functions. ACCRINTM Returns the accrued interest for a security that pays interest at maturity. See the Financial functions. ACOS Returns the arccosine (in radians) of a number. There's no equivalent Anaplan function. ACOSH Returns the inverse hyperbolic cosine of a number. There's no equivalent Anaplan function. ADDRESS Returns a text representation of a cell address. Use the NAME function. AGGREGATE Apply functions such as AVERAGE, SUM, COUNT, MAX, or MIN and ignores errors or hidden rows. Anaplan aggregates this as part of the module functionality. Set the aggregation level in the module. AMORDEGRC Returns the linear depreciation of an asset for each accounting period, on a prorated basis. See the Financial functions. AMORLINC Returns the depreciation of an asset for each accounting period, on a prorated basis. See the Financial functions. AND Returns TRUE if all of its arguments are TRUE. Use operators and constants with your data to create calculations and find the data you need. AREAS Returns the number of ranges in a reference. There's no equivalent Anaplan function. ASIN Returns the arcsine (in radians) of a number. There's no equivalent Anaplan function. ASINH Returns the inverse hyperbolic sine of a number. There's no equivalent Anaplan function. ATAN Returns the arctangent (in radians) of a number. There's no equivalent Anaplan function. ATAN2 Returns the arctangent (in radians) of (x,y) coordinates. There's no equivalent Anaplan function. ATANH Returns the inverse hyperbolic tangent of a number. There's no equivalent Anaplan function. AVEDEV Returns the average of the absolute deviations of the numbers provided. There's no equivalent Anaplan function, but can be built using a calculation. AVERAGE Returns the average of the numbers provided. Use the x[AVERAGE:y] aggregation function. AVERAGEA Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0. There's no equivalent Anaplan function. AVERAGEIF Returns the average of all numbers in a range of cells, based on a criterion. Use the x[AVERAGE:y] aggregation function to calculate the average for a specified range of values. AVERAGEIFS Returns the average of all numbers in a range of cells, based on multiple criteria Use the x[AVERAGE:y] aggregation function to calculate the average for a specified range of values.