Comparisons of Microsoft Excel functions to those available in Anaplan.
| 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. |
