Comparisons of Microsoft Excel functions to those available in Anaplan.

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

 Excel function Excel description Anaplan solution CEILING Returns a number rounded up based on a multiple of significance. Use the MROUND function to round up to the nearest desired multiple. CEILING.PRECISE Returns a number rounded up to the nearest integer or to the nearest multiple of significance. Use the MROUND function to round up to the nearest desired multiple. CELL Used to retrieve information about a cell. For example, contents, formatting, or size. There is no equivalent Anaplan function. CHAR Returns the character based on the ASCII value. There is no equivalent Anaplan function. CHIDIST Returns the one-tailed probability of the chi-squared distribution. There is no equivalent Anaplan function, but can be built using a calculation. CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution. There is no equivalent Anaplan function, but can be built using a calculation. CHITEST Returns the value from the chi-squared distribution. There is no equivalent Anaplan function, but can be built using a calculation. CHOOSE Returns a value from a list of values based on a given position. Use the FINDITEM function to match text to an item in a list, or match text to an item in a time period list. This can match on an item name or code. CLEAN Removes all non-printable characters from a string. There is no equivalent Anaplan function. CODE Returns the ASCII value of a character or the first character in a cell. Use the CODE function to enter several conditions, and the AND function to test if all conditions are met. COLUMN Returns the column number of a cell reference. Use the ITEM calculation function. COLUMNS Returns the number of columns in a cell reference. There is no equivalent Anaplan function, but can be built using a calculation. COMBIN Returns the number of combinations for a specified number of items. There is no equivalent Anaplan function, but can be built using a calculation. COMBINA Returns the number of combinations for a specified number of items and includes repetitions. There is no equivalent Anaplan function, but can be built using a calculation. COMPLEX Converts coefficients (real and imaginary) into a complex number. There is no equivalent Anaplan function, but can be built using a calculation. CONCAT Joins two or more strings together. Use the & operator to concatenate two or more text strings. CONCATENATE Joins two or more strings together. This has been replaced by CONCAT function. Use the & operator to concatenate two or more text strings. CONCATENATE with & Joins two or more strings together using the & operator. Use the & operator to concatenate two or more text strings. CONVERT Convert a number from one measurement unit to another measurement unit. Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a: List-formatted line item Time period-formatted item Property from the source with a dimension of the target line item. COS Returns the cosine of an angle. There is no equivalent Anaplan function, but can be built using a calculation. COSH Returns the hyperbolic cosine of a number. There is no equivalent Anaplan function, but can be built using a calculation. COUNT Counts the number of cells that contain numbers as well as the number of arguments that contain numbers. Use the IF THEN ELSE function to create a count, and the SUM function to get the total for that line item. COUNTA Counts the number of cells that are not empty, as well as the number of value arguments provided. Use the IF THEN ELSE function to create a count, and the SUM function to get the total for that line item. COUNTBLANK Counts the number of empty cells in a range. Use the IF THEN ELSE function to create a count, and the SUM function to get the total for that line item. COUNTIF Counts the number of cells in a range, that meets the specified criteria. Use the IF THEN ELSE function to create a count, and the SUM function to get the total for that line item. COUNTIFS Counts the number of cells in a range, that meets a single or multiple criteria. Use the IF THEN ELSE function to create a count, and the SUM function to get the total for that line item. COUPDAYBS Returns the number of days from the beginning of a coupon period until its settlement date. Use the COUPDAYBS function. COUPDAYS Returns the number of days in the coupon period that contains the settlement date. Use the COUPDAYS function. COUPDAYSNC Returns the number of days from the settlement date to the next coupon date. Use the COUPDAYSNC function. COUPNCD Returns a number that represents the next coupon date after the settlement date. Use the COUPNCD function. COUPNUM Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. Use the COUPNUM function. COUPPCD Returns a number that represents the previous coupon date before the settlement date. Use the COUPPCD function. COVAR Returns the covariance, the average of the products of deviations for two data sets. 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.