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
CEILINGReturns a number rounded up based on a multiple of significance.Use the MROUND function to round up to the nearest desired multiple.
CEILING.PRECISEReturns 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.
CELLUsed to retrieve information about a cell. For example, contents, formatting, or size.There is no equivalent Anaplan function.
CHARReturns the character based on the ASCII value.There is no equivalent Anaplan function.
CHIDISTReturns the one-tailed probability of the chi-squared distribution.There is no equivalent Anaplan function, but can be built using a calculation.
CHIINVReturns 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.
CHITESTReturns the value from the chi-squared distribution.There is no equivalent Anaplan function, but can be built using a calculation.
CHOOSEReturns 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.
CLEANRemoves all non-printable characters from a string.There is no equivalent Anaplan function.
CODEReturns 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.
COLUMNReturns the column number of a cell reference.Use the ITEM calculation function.
COLUMNSReturns the number of columns in a cell reference.There is no equivalent Anaplan function, but can be built using a calculation.
COMBINReturns the number of combinations for a specified number of items.There is no equivalent Anaplan function, but can be built using a calculation.
COMBINAReturns 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.
COMPLEXConverts coefficients (real and imaginary) into a complex number.There is no equivalent Anaplan function, but can be built using a calculation.
CONCATJoins two or more strings together.Use the & operator to concatenate two or more text strings.
CONCATENATEJoins 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.
CONVERTConvert 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.
COSReturns the cosine of an angle.There is no equivalent Anaplan function, but can be built using a calculation.
COSHReturns the hyperbolic cosine of a number.There is no equivalent Anaplan function, but can be built using a calculation.
COUNTCounts 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.
COUNTACounts 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.
COUNTBLANKCounts 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.
COUNTIFCounts 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.
COUNTIFSCounts 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.
COUPDAYBSReturns the number of days from the beginning of a coupon period until its settlement date.Use the COUPDAYBS function.
COUPDAYSReturns the number of days in the coupon period that contains the settlement date.Use the COUPDAYS function.
COUPDAYSNCReturns the number of days from the settlement date to the next coupon date.Use the COUPDAYSNC function.
COUPNCDReturns a number that represents the next coupon date after the settlement date.Use the COUPNCD function.
COUPNUMReturns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.Use the COUPNUM function.
COUPPCDReturns a number that represents the previous coupon date before the settlement date.Use the COUPPCD function.
COVARReturns 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.