| EXCEL function | Excel Description | ANAPLAN Solution |
| ABS | Returns the absolute value of a number | ABS—Returns the absolute value of a number. |
| ACCRINT | Returns the accrued interest for a security that pays interest on a periodic basis | |
| ACCRINTM | Returns the accrued interest for a security that pays interest at maturity | |
| ACOS | Returns the arccosine (in radians) of a number | No native Anaplan function |
| ACOSH | Returns the inverse hyperbolic cosine of a number | No native Anaplan function |
| ADDRESS | Returns a text representation of a cell address | NAME |
| AGGREGATE | Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows | Anaplan aggregates as part of the module functionality, set the aggregation level in the module |
| AMORDEGRC | Returns the linear depreciation of an asset for each accounting period, on a prorated basis | |
| AMORLINC | Returns the depreciation of an asset for each accounting period, on a prorated basis | |
| x[ALL:y] | AND | Returns TRUE if all conditions are TRUE |
| AREAS | Returns the number of ranges in a reference | No native Anaplan function |
| ASIN | Returns the arcsine (in radians) of a number | No native Anaplan function |
| ASINH | Returns the inverse hyperbolic sine of a number | No native Anaplan function |
| ATAN | Returns the arctangent (in radians) of a number | No native Anaplan function |
| ATAN2 | Returns the arctangent (in radians) of (x,y) coordinates | No native Anaplan function |
| ATANH | Returns the inverse hyperbolic tangent of a number | No native Anaplan function |
| AVEDEV | Returns the average of the absolute deviations of the numbers provided | No native Anaplan function: can be built using calculation |
| AVERAGE | Returns the average of the numbers provided | x[AVERAGE:y] |
| AVERAGEA | Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0 |
No native Anaplan function |
| AVERAGEIF | Returns the average of all numbers in a range of cells, based on a given criteria | x[AVERAGE:y]—calculates the average for a specified range of values. |
| AVERAGEIFS | Returns the average of all numbers in a range of cells, based on multiple criteria | x[AVERAGE:y]—calculates the average for a specified range of values. |
| BETA.DIST | Returns the beta distribution | No native Anaplan function |
| BETA.INV | Returns the inverse of the cumulative beta probability density function | No native Anaplan function |
| BETADIST | Returns the cumulative beta probability density function | No native Anaplan function |
| BETAINV | Returns the inverse of the cumulative beta probability density function | No native Anaplan function: can be built using calculation |
| BIN2DEC | Converts a binary number to a decimal number | No native Anaplan function: can be built using calculation |
| BIN2HEX | Converts a binary number to a hexadecimal number | No native Anaplan function: can be built using calculation |
| BIN2OCT | Converts a binary number to an octal number | No native Anaplan function: can be built using calculation |
| BINOM.DIST | Returns the individual term binomial distribution probability | No native Anaplan function: can be built using calculation |
| BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion | No native Anaplan function: can be built using calculation |
| BINOMDIST | Returns the individual term binomial distribution probability | No native Anaplan function: can be built using calculation |
| CEILING | Returns a number rounded up based on a multiple of significance | MROUND—round to the nearest desired multiple. |
| CEILING.PRECISE | Returns a number rounded up to the nearest integer or to the nearest multiple of significance | MROUND—round to the nearest desired multiple. |
| CELL | Used to retrieve information about a cell such as contents, formatting, size, etc. |
No native Anaplan function |
| CHAR | Returns the character based on the ASCII value | No native Anaplan function. |
| CHIDIST | Returns the one-tailed probability of the chi-squared distribution | No native Anaplan function: can be built using calculation |
| CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution | No native Anaplan function: can be built using calculation |
| CHITEST | Returns the value from the chi-squared distribution | No native Anaplan function: can be built using calculation |
| CHOOSE | Returns a value from a list of values based on a given position | FINDITEM—matches text to an item in a list or matches text to an item in a time period list (can match on item name or code). |
| CLEAN | Removes all non-printable characters from a string |
No native Anaplan function |
| CODE | Returns the ASCII value of a character or the first character in a cell | CODE—enter several conditions and the AND function tests to see if all conditions are met. |
| COLUMN | Returns the column number of a cell reference | ITEM. |
| COLUMNS | Returns the number of columns in a cell reference | No native Anaplan function: can be built using calculation |
| COMBIN | Returns the number of combinations for a specified number of items | No native Anaplan function: can be built using calculation |
| COMBINA | Returns the number of combinations for a specified number of items and includes repetitions | No native Anaplan function: can be built using calculation |
| COMPLEX | Converts coefficients (real and imaginary) into a complex number | No native Anaplan function: can be built using calculation |
| CONCAT | Used to join two or more strings together | &—concatenates two or more text strings. |
| CONCATENATE | Used to join two or more strings together (replaced by CONCAT Function) | &—concatenates two or more text strings. |
| CONCATENATE with & | Used to join two or more strings together using the & operator | &—concatenates two or more text strings. |
| CONVERT | Convert a number from one measurement unit to another measurement unit | LOOKUP—looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| COS | Returns the cosine of an angle | No native Anaplan function: can be built using calculation |
| COSH | Returns the hyperbolic cosine of a number | No native Anaplan function: can be built using calculation |
| COUNT | Counts the number of cells that contain numbers as well as the number of arguments that contain numbers | Use an IF THEN statement with a SUM function to accomplish the same goals. Use IF THEN ELSE to create a count, then use SUM 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 | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
| COUNTBLANK | Counts the number of empty cells in a range | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
| COUNTIF | Counts the number of cells in a range, that meets a given criteria | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
| COUNTIFS | Counts the number of cells in a range, that meets a single or multiple criteria | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
| COUPDAYBS | Returns the number of days from the beginning of a coupon period until its settlement date | COUPDAYBS |
| COUPDAYS | Returns the number of days in the coupon period that contains the settlement date | COUPDAYS |
| COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date | COUPDAYSNC |
| COUPNCD | Returns a number that represents the next coupon date after the settlement date | COUPNCD |
| COUPNUM | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon | COUPNUM |
| COUPPCD | Returns a number that represents the previous coupon date before the settlement date | COUPPCD |
| COVAR | Returns the covariance, the average of the products of deviations for two data sets | No native Anaplan function: can be built using calculation |
| DATE | Returns the serial date value for a date | DATE—converts numbers yyyy, mm and dd to a date. Date format depends on your locale. |
| DATEDIF | Returns the difference between two date values, based on the interval specified | DECUMULATE—calculates the difference in a value in the current period vs previous period. |
| DATEVALUE | Returns the serial number of a date |
Function not required by Anaplan—use Date Settings. |
| DAVERAGE | Averages all numbers in a column in a list or database, based on a given criteria |
Function not required by Anaplan—use Summary method AVERAGE. |
| DAY | Returns the day of the month (a number from 1 to 31) given a date value | DAY—converts a date to a day in number format. Date format depends on your locale. |
| DAYS | Returns the number of days between two dates | DAYS—number of days in a time period. Takes no parameter or a single time period parameter. Returns the number of days in a time period: |
| DAYS360 | Returns the number of days between two dates based on a 360-day year | DAYS—number of days in a time period. Takes no parameter or a single time period parameter. Returns the number of days in a time period: |
| DB | Returns the depreciation of an asset based on the fixed-declining balance method | See Financial Functions |
| DCOUNT | Returns the number of cells in a column or database that contains numeric values and meets a given criteria | Function not required by Anaplan—use SUM |
| DCOUNTA | Returns the number of cells in a column or database that contains non-blank values and meets a given criteria | Function not required by Anaplan—use SUM |
| DDB | Returns the depreciation of an asset based on the double-declining balance method | |
| DEGREES | Converts radians into degrees | No native Anaplan function: can be built using calculation |
| DGET | Retrieves from a database a single record that matches a given criteria | ITEM |
| DMAX | Returns the largest number in a column in a list or database, based on a given criteria | x[MAX:y] |
| DMIN | Returns the smallest number in a column in a list or database, based on a given criteria | x[MIN:y] |
| DOLLAR | Converts a number to text, using a currency format | No native Anaplan function: can be built using calculation |
| DPRODUCT | Returns the product of the numbers in a column in a list or database, based on a given criteria |
No native Anaplan function: can be built using calculation |
| DSTDEV | Returns the standard deviation of a population based on a sample of numbers |
No native Anaplan function: can be built using calculation |
| DSTDEVP | Returns the standard deviation of a population based on the entire population of numbers |
No native Anaplan function: can be built using calculation |
| DSUM | Sums the numbers in a column or database that meets a given criteria | |
| DURATION | Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield | DURATION |
| DVAR | Returns the variance of a population based on a sample of numbers |
Using SELECT and COLLECT with line items to calculate Variance |
| DVARP | Returns the variance of a population based on the entire population of numbers |
Using SELECT and COLLECT with line items to calculate Variance |
| EDATE | Adds a specified number of months to a date and returns the result as a serial date | OFFSET—returns a value from a specified number of periods in advance |
| EOMONTH | Calculates the last day of the month after adding a specified number of months to a date | END |
| ERROR.TYPE | Returns the numeric representation of an Excel error |
No native Anaplan function: can be built using calculation. |
| EVEN | Rounds a number up to the nearest even integer | No native Anaplan function: can be built using calculation |
| EXACT | Compares two strings and returns TRUE if both values are the same | COMPARE—compares text values; result is 0 if they match, 1 or -1 if not matched. |
| EXP | Returns e raised to the nth power | EXP—returns e raised to the nth power. |
| FACT | Returns the factorial of a number | No native Anaplan function: can be built using calculation. |
| FALSE | Returns a logical value of FALSE |
Anaplan Functionality: Boolean argument |
| FIND | Returns the location of a substring in a string (case-sensitive) | FIND—look for a text string within a text-formatted item, starting at a specified character number (result is a number that denotes the character position). |
| FIXED | Returns a text representation of a number rounded to a specified number of decimal places | VALUE—converts a numeric value in a text field to a number format. |
| FLOOR | Returns a number rounded down based on a multiple of significance | No native Anaplan function: can be built using calculation |
| FORECAST | Returns a prediction of a future value based on existing values provided | FV |
| FREQUENCY | Returns how often values occur within a set of data. It returns a vertical array of numbers |
No native Anaplan function: can be built using calculation |
| FV | Returns the future value of an investment | FV |
| GROWTH | Returns the predicted exponential growth based on existing values provided | EXP distributed along timeline |
| HLOOKUP | Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number | LOOKUP—looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| HOUR | Returns the hours (a number from 0 to 23) from a time value | No native Anaplan function: can be built using calculation |
| HYPERLINK | Creates a shortcut to a file or Internet address | MAKELINK—composes a click-able URL |
| IF | Returns one value if the condition is TRUE or another value if the condition is FALSE | IF THEN ELSE—conditional formula |
| IF (more than 7) | Nest more than seven IF functions | IF THEN ELSE—conditional formula |
| IF (up to 7) | Nest up to seven IF functions | IF THEN ELSE—conditional formula |
| IFERROR | Used to return an alternate value if a formula results in an error | IF THEN ELSE |
| IFNA | Used to return an alternate value if a formula results in #N/A error | IF THEN ELSE |
| IFS | Specify multiple IF conditions within a function | IF THEN ELSE |
| INDEX | Returns either the value or the reference to a value from a table or range | FINDITEM—matches text to an item in a list or matches text to an item in a time period list (can match on item name or code) |
| INDIRECT | Returns the reference to a cell based on its string representation | Use LOOKUP and TEXT |
| INFO | Returns information about the operating environment |
No native Anaplan function: can be built using calculation |
| INT | Returns the integer portion of a number | Handled by module formatting. |
| INTERCEPT | Returns the y-axis intersection point of a line using x-axis values and y-axis values |
No native Anaplan function: can be built using calculation |
| IPMT | Returns the interest payment for an investment | RATE—calculates a per period interest rate |
| IRR | Returns the internal rate of return for a series of cash flows | IRR |
| ISBLANK | Used to check for blank or null values | ISBLANK—tests whether an item is blank |
| ISERR | Used to check for error values except #N/A | No native Anaplan function: can be built using calculation |
| ISERROR | Used to check for error values | No native Anaplan function: can be built using calculation |
| ISLOGICAL | Used to check for a logical value (TRUE or FALSE) | No native Anaplan function: can be built using calculation |
| ISNA | Used to check for #N/A error | No native Anaplan function: can be built using calculation |
| ISNONTEXT | Used to check for a value that is not text | No native Anaplan function: can be built using calculation |
| ISNUMBER | Used to check for a numeric value | No native Anaplan function: can be built using calculation |
| ISOWEEKNUM | Returns the ISO week number for a date |
No native Anaplan function—Use the internal time structure within Anaplan |
| ISPMT | Returns the interest payment for an investment | RATE—calculates a per period interest rate. |
| ISREF | Used to check for a reference | No native Anaplan function: can be built using calculation |
| ISTEXT | Used to check for a text value | No native Anaplan function: can be built using calculation |
| LARGE | Returns the nth largest value from a set of values |
No native Anaplan function: can be built using calculation |
| LEFT | Extract a substring from a string, starting from the left-most character | LEFT—extracts a substring from a string starting at the leftmost character |
| LEN | Returns the length of the specified string | LEN—variant of LENGTH. Returns the number of characters in a text string |
| LINEST | Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line |
No native Anaplan function: can be built using calculation |
| LN | Returns the natural logarithm of a number | LN—returns the natural logarithm of a number, based on the constant e |
| LOG | Returns the logarithm of a number to a specified base | LOG—returns the logarithm of a number to the specified base |
| LOG10 | Returns the base-10 logarithm of a number | LOG—returns the logarithm of a number to the specified base |
| LOOKUP | Returns a value from a range (one row or one column) or from an array | LOOKUP—looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| LOWER | Converts all letters in the specified string to lowercase | LOWER—converts text to lowercase |
| MATCH | Searches for a value in an array and returns the relative position of that item | LOOKUP—looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| MAX | Returns the largest value from the numbers provided | MAX |
| MAXA | Returns the largest value from the values provided (numbers, text and logical values) | x[MAX_y] |
| MDETERM | Returns the matrix determinant of an array | No native Anaplan function: can be built using calculation |
| MDURATION | Returns the modified Macauley duration for a security with an assumed par value of $100 | MDURATION |
| MEDIAN | Returns the median of the numbers provided |
No native Anaplan function: can be built using calculation |
| MID | Extracts a substring from a string (starting at any position) | MID—extract a substring from a string starting at any character |
| MIN | Returns the smallest value from the numbers provided | MIN—minimum of selected line items |
| MINA | Returns the smallest value from the values provided (numbers, text and logical values) | MIN—minimum of selected line items |
| MINUTE | Returns the minutes (a number from 0 to 59) from a time value |
No native Anaplan function: can be built using calculation |
| MINVERSE | Returns the inverse matrix for a given matrix | No native Anaplan function: can be built using calculation |
| MIRR | Returns the modified internal rate of return for a series of cash flows | IRR |
| MMULT | Returns the matrix product of two arrays | No native Anaplan function: can be built using calculation |
| MOD | Returns the remainder after a number is divided by a divisor | Modulus: remainder after dividing a dividend by a divisor |
| MONTH | Returns the month (a number from 1 to 12) given a date value | MONTH—converts a date or a time period to a calendar month as number |
| N | Converts a value to a number | VALUE |
| NA | Returns the #N/A error value |
No native Anaplan function |
| NETWORKDAYS | Returns the number of work days between two dates, excluding weekends and holidays |
Function not supported by Anaplan: can be built using calculation |
| NETWORKDAYS.INTL | Returns the number of work days between two dates, excluding weekends and holidays |
Function supported by Anaplan in Settings |
| NOT | Returns the reversed logical value | NOT |
| NOW | Returns the current system date and time | No native Anaplan function: can be built by creating a module called Today with one date-formatted line item which is selected when required |
| NPER | Returns the number of periods for an investment | NPER |
| NPV | Returns the net present value of an investment | NPV |
| ODD | Rounds a number up to the nearest odd integer | No native Anaplan function: can be built using ROUND calculation |
| OFFSET | Returns a reference to a range that is offset a number of rows and columns | No native Anaplan function: can be built using calculation |
| OR | Returns TRUE if any of the conditions are TRUE | x[ANY_y] |
| PERCENTILE | Returns the nth percentile from a set of values |
No native Anaplan function: can be built using calculation |
| PERCENTRANK | returns the rank of a value in a set of values as a percentage of the set |
No native Anaplan function: can be built using calculation: Percentile = (number of values below X) + 0.5)/total number of values*100
|
| PERMUT | Returns the number of permutations for a specified number of items |
For permutations where repetition is allowed, use POWER, with the number of items as x and the number of permutations as n. |
| PI | Returns the mathematical constant called pi | No native Anaplan function: can be built using calculation |
| PMT | Returns the payment amount for a loan | PMT—Take a date as parameter and returns a time period as result |
| POWER | Returns the result of a number raised to a given power | POWER—Raise a value to a power |
| PPMT | Returns the payment on the principal for a particular payment | |
| PRICE | Returns the price per $100 face value of a security that pays periodic interest | PRICE |
| PRODUCT | Multiplies the numbers and returns the product | Using a intermediate line item with the Summary as PRODUCT |
| PROPER | Sets the first character in each word to uppercase and the rest to lowercase | None: can be achieved through Formula |
| PV | Returns the present value of an investment | PV—calculates the present value of future cash-flows |
| QUARTILE | Returns the quartile from a set of values |
No native Anaplan function: can be built using calculation |
| RADIANS | Converts degrees into radians | No native Anaplan function: can be built using calculation |
| RAND | Returns a random number that is greater than or equal to 0 and less than 1 | No native Anaplan function: can be built using calculation |
| RANDBETWEEN | Returns a random number that is between a bottom and top range | No native Anaplan function: can be built using calculation |
| RANK | Returns the rank of a number within a set of numbers | RANK—orders a set of values and assigns rankings from 1 to a specified ending rank |
| RATE | Returns the interest rate for an annuity | RATE—calculates a per period interest rate |
| REPLACE | Replaces a sequence of characters in a string with another set of characters | Use FIND, LEN, LEFT, RIGHT,& |
| REPT | Returns a repeated text value a specified number of times | No native Anaplan function: can be built using calculation |
| RIGHT | Extracts a substring from a string starting from the right-most character | RIGHT—extracts a substring from a string starting at the rightmost character |
| ROMAN | Converts a number to roman numeral | No native Anaplan function: can be built using calculation |
| ROUND | Returns a number rounded to a specified number of digits | ROUND |
| ROUNDDOWN | Returns a number rounded down to a specified number of digits | ROUND |
| ROUNDUP | Returns a number rounded up to a specified number of digits | ROUND |
| ROW | Returns the row number of a cell reference | ITEM |
| ROWS | Returns the number of rows in a cell reference | No native Anaplan function: can be built using calculation |
| SEARCH | Returns the location of a substring in a string | FIND—look for a text string within a text-formatted item, starting at a specified character number (result is a number that denotes the character position). |
| SECOND | Returns the seconds (a number from 0 to 59) from a time value | No native Anaplan function: can be built using calculation |
| SIGN | Returns the sign of a number | SIGN—show the sign of a number (result = -1 if the value is negative, 1 if positive, 0 if zero) |
| SIN | Returns the sine of an angle | No native Anaplan function: can be built using calculation |
| SINH | Returns the hyperbolic sine of a number | No native Anaplan function: can be built using calculation |
| SLN | Returns the depreciation of an asset based on the straight-line depreciation method | SPREAD |
| SLOPE | Returns the slope of a regression line based on the data points identified by known_y_values and known_x_values |
No native Anaplan function: can be built using calculation |
| SMALL | Returns the nth smallest value from a set of values |
No native Anaplan function: can be built using calculation |
| SQRT | Returns the square root of a number | SQRT—square root of a value |
| STDEV | Returns the standard deviation of a population based on a sample of numbers |
No native Anaplan function: can be built using calculation |
| STDEVA | Returns the standard deviation of a population based on a sample of numbers, text, and logical values |
No native Anaplan function: can be built using calculation |
| STDEVP | Returns the standard deviation of a population based on an entire population of numbers |
No native Anaplan function: can be built using calculation |
| STDEVPA | Returns the standard deviation of a population based on an entire population of numbers, text, and logical values |
No native Anaplan function: can be built using calculation |
| SUBSTITUTE | Replaces a set of characters with another | Use FIND, LEN, & |
| SUBTOTAL | Returns the subtotal of the numbers in a column in a list or database | SUM & SELECT—first it selects a specific item from one or more of the hierarchy lists, then it sums values based on a list-formatted line item or property in the source that matches a dimension in the target. |
| SUM | Adds all numbers in a range of cells | SUM—sums values based on a list-formatted or time period-formatted line item or property in the source that matches a dimension in the target. |
| SUMIF | Adds all numbers in a range of cells based on one criteria | Create intermediate module—configure Rows as criteria, column as line item which SUM criteria |
| SUMIFS | Adds all numbers in a range of cells, based on a single or multiple criteria | Create intermediate module—configure Rows as criteria, column as line item which SUM criteria |
| SUMPRODUCT | Multiplies the corresponding items in the arrays and returns the sum of the results |
No native Anaplan function: can be built using calculation |
| SUMSQ | Returns the sum of the squares of a series of values | Use POWER with SUM. |
| SUMX2MY2 | Returns the sum of the difference of squares between two arrays | No native Anaplan function: can be built using calculation |
| SUMX2PY2 | Returns the sum of the squares of corresponding items in the arrays | No native Anaplan function: can be built using calculation |
| SUMXMY2 | Returns the sum of the squares of the differences between corresponding items in the arrays | No native Anaplan function: can be built using calculation |
| SYD | Returns the depreciation of an asset based on the sum-of-years' digits depreciation method |
No native Anaplan function: can be built using calculation |
| T | Returns the text referred to by a value | TEXT—converts a numeric value to text. |
| TAN | Returns the tangent of an angle | No native Anaplan function: can be built using calculation |
| TANH | Returns the hyperbolic tangent of a number | No native Anaplan function: can be built using calculation |
| TEXT | Returns a value converted to text with a specified format | TEXT—converts a numeric value to text |
| TEXTJOIN | Used to join two or more strings together separated by a delimiter |
&—concatenates two or more text strings |
| TIME | Returns a decimal number given an hour, minute and second value | No native Anaplan function: can be built using calculation |
| TIMEVALUE | Returns the serial number of a time | No native Anaplan function: can be built using calculation |
| TODAY | Returns the current system date | No native Anaplan function: can be built using calculation |
| TRANSPOSE | Returns a transposed range of cells | Create a new module with pivoted view |
| TRIM | Returns a text value with the leading and trailing spaces removed | Use LEN, LEFT, RIGHT |
| TRUE | Returns a logical value of TRUE |
Anaplan functionality: Boolean argument |
| TRUNC | Returns a number truncated to a specified number of digits | Handled by module formatting |
| TYPE | Returns the type of a value |
No native Anaplan function |
| UPPER | Convert text to all uppercase | UPPER—converts text to uppercase |
| VALUE | Converts a text value that represents a number to a number | VALUE—converts a numeric value in a text field to a number format |
| VAR | Returns the variance of a population based on a sample of numbers | Using SELECT and COLLECT with line items to calculate Variance |
| VARA | Returns the variance of a population based on a sample of numbers, text, and logical values | Using SELECT and COLLECT with line items to calculate Variance |
| VARP | Returns the variance of a population based on an entire population of numbers | Using SELECT and COLLECT with line items to calculate Variance |
| VARPA | Returns the variance of a population based on an entire population of numbers, text, and logical values | Using SELECT and COLLECT with line items to calculate Variance |
| VDB | Returns the depreciation of an asset based on a variable declining balance depreciation method | |
| VLOOKUP | Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position | LOOKUP—looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| WEEKDAY | Returns a number representing the day of the week, given a date value | WEEKDAY—takes a date and returns a number 1 to 7 for the day-of-week number. An optional Type parameter can be used to set the start day for the day-of-week count. |
| WEEKNUM | Returns the week number for a date |
No native Anaplan function. Use the internal time structure within Anaplan: can be built using calculation. |
| WORKDAY | Adds a specified number of work days to a date and returns the result as a serial date |
No native Anaplan function. Use the internal time structure within Anaplan: can be built using calculation. |
| WORKDAY.INTL | Adds a specified number of work days to a date and returns the result as a serial date (customizable weekends) |
No native Anaplan function. Use the internal time structure within Anaplan—can be built using calculation. |
| XIRR | Returns the internal rate of return for a series of cash flows that may not be periodic | |
| YEAR | Returns a four-digit year (a number from 1900 to 9999) given a date value | YEAR—converts a date or a time period to a year in number format. |
| YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date) | YEARFRAC |
| YIELD | Returns the yield on a security that pays periodic interest | YIELD |
Some of the functions available in Excel are directly comparable with Anaplan Functions.