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
BETA.DISTReturns the beta distribution.There is no equivalent Anaplan function.
BETA.INVReturns the inverse of the cumulative beta probability density function.There is no equivalent Anaplan function.
BETADISTReturns the cumulative beta probability density function.There is no equivalent Anaplan function.
BETAINVReturns the inverse of the cumulative beta probability density function.There is no equivalent Anaplan function, but can be built using a calculation.
BIN2DECConverts a binary number to a decimal number.There is no equivalent Anaplan function, but can be built using a calculation.
BIN2HEXConverts a binary number to a hexadecimal number.There is no equivalent Anaplan function, but can be built using a calculation.
BIN2OCTConverts a binary number to an octal number.There is no equivalent Anaplan function, but can be built using a calculation.
BINOM.DISTReturns the individual term binomial distribution probability.There is no equivalent Anaplan function, but can be built using a calculation.
BINOM.INVReturns 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.
BINOMDISTReturns the individual term binomial distribution probability.There is no equivalent Anaplan function, but can be built using a calculation.

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.