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 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:
|
| 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. |
