Comparisons of Microsoft Excel functions to those available in Anaplan.

Excel function | Excel description | Anaplan solution |

BETA.DIST | Returns the beta distribution. | There is no equivalent Anaplan function. |

BETA.INV | Returns the inverse of the cumulative beta probability density function. | There is no equivalent Anaplan function. |

BETADIST | Returns the cumulative beta probability density function. | There is no equivalent Anaplan function. |

BETAINV | Returns the inverse of the cumulative beta probability density function. | There is no equivalent Anaplan function, but can be built using a calculation. |

BIN2DEC | Converts a binary number to a decimal number. | There is no equivalent Anaplan function, but can be built using a calculation. |

BIN2HEX | Converts a binary number to a hexadecimal number. | There is no equivalent Anaplan function, but can be built using a calculation. |

BIN2OCT | Converts a binary number to an octal number. | There is no equivalent Anaplan function, but can be built using a calculation. |

BINOM.DIST | Returns the individual term binomial distribution probability. | There is no equivalent Anaplan function, but can be built using a calculation. |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion. | There is no equivalent Anaplan function, but can be built using a calculation. |

BINOMDIST | Returns the individual term binomial distribution probability. | There is no equivalent Anaplan function, but can be built using a calculation. |

Disclaimer

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