Comparisons of Microsoft Excel functions to those available in Anaplan.
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 onetailed probability of the chisquared distribution.  There is no equivalent Anaplan function, but can be built using a calculation. 
CHIINV  Returns the inverse of the onetailed probability of the chisquared distribution.  There is no equivalent Anaplan function, but can be built using a calculation. 
CHITEST  Returns the value from the chisquared 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 nonprintable 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:

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. 