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

Disclaimer

We update Anapedia content regularly to provide the most up-to-date instructions.