Comparisons of Microsoft Excel functions to those available in Anaplan.

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

A B C D E F G H I L M N O P Q R S T U V W X Y

Excel functionExcel descriptionAnaplan solution
ABSReturns the absolute value of a number.Use the ABS function.
ACCRINTReturns the accrued interest for a security that pays interest on a periodic basis.See the Financial functions.
ACCRINTMReturns the accrued interest for a security that pays interest at maturity.See the Financial functions.
ACOSReturns the arccosine (in radians) of a number.There's no equivalent Anaplan function.
ACOSHReturns the inverse hyperbolic cosine of a number.There's no equivalent Anaplan function.
ADDRESSReturns a text representation of a cell address.Use the NAME function.
AGGREGATEApply 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.
AMORDEGRCReturns the linear depreciation of an asset for each accounting period, on a prorated basis.See the Financial functions.
AMORLINCReturns the depreciation of an asset for each accounting period, on a prorated basis.See the Financial functions.
ANDReturns TRUE if all of its arguments are TRUE.Use operators and constants with your data to create calculations and find the data you need.
AREASReturns the number of ranges in a reference.There's no equivalent Anaplan function.
ASINReturns the arcsine (in radians) of a number.There's no equivalent Anaplan function.
ASINHReturns the inverse hyperbolic sine of a number.There's no equivalent Anaplan function.
ATANReturns the arctangent (in radians) of a number.There's no equivalent Anaplan function.
ATAN2Returns the arctangent (in radians) of (x,y) coordinates.There's no equivalent Anaplan function.
ATANHReturns the inverse hyperbolic tangent of a number.There's no equivalent Anaplan function.
AVEDEVReturns the average of the absolute deviations of the numbers provided.There's no equivalent Anaplan function, but can be built using a calculation.
AVERAGEReturns the average of the numbers provided.Use the x[AVERAGE:y] aggregation function.
AVERAGEAReturns the average of the numbers provided and treats TRUE as 1 and FALSE as 0.There's no equivalent Anaplan function.
AVERAGEIFReturns 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.
AVERAGEIFSReturns the average of all numbers in a range of cells, based on multiple criteriaUse the x[AVERAGE:y] aggregation function to calculate the average for a specified range of values.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.