Some Excel functions are directly comparable with Anaplan functions.
A
Excel function  Excel description  Anaplan solution 
ABS  Returns the absolute value of a number.  Use the ABS function. 
ACCRINT  Returns the accrued interest for a security that pays interest on a periodic basis.  See the Financial Functions. 
ACCRINTM  Returns the accrued interest for a security that pays interest at maturity.  See the Financial Functions. 
ACOS  Returns the arccosine (in radians) of a number.  There is no native Anaplan function. 
ACOSH  Returns the inverse hyperbolic cosine of a number.  There is no native Anaplan function. 
ADDRESS  Returns a text representation of a cell address.  Use the NAME function. 
AGGREGATE  Apply functions such as AVERAGE, SUM, COUNT, MAX or MIN and ignores errors or hidden rows.  Anaplan aggregates this 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.  See the Financial Functions. 
AMORLINC  Returns the depreciation of an asset for each accounting period, on a prorated basis.  See the Financial Functions. 
AND  Returns TRUE if all of its arguments are TRUE.  Use operators and constants with your data to create calculations and find the data you need. 
AREAS  Returns the number of ranges in a reference.  There is no native Anaplan function. 
ASIN  Returns the arcsine (in radians) of a number.  There is no native Anaplan function. 
ASINH  Returns the inverse hyperbolic sine of a number.  There is no native Anaplan function. 
ATAN  Returns the arctangent (in radians) of a number.  There is no native Anaplan function. 
ATAN2  Returns the arctangent (in radians) of (x,y) coordinates.  There is no native Anaplan function. 
ATANH  Returns the inverse hyperbolic tangent of a number.  There is no native Anaplan function. 
AVEDEV  Returns the average of the absolute deviations of the numbers provided.  There is no native Anaplan function, but can be built using a calculation. 
AVERAGE  Returns the average of the numbers provided.  Use the x[AVERAGE:y] function. 
AVERAGEA  Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0.  There is no native Anaplan function. 
AVERAGEIF  Returns the average of all numbers in a range of cells, based on a criterion.  Use the x[AVERAGE:y] function to calculate the average for a specified range of values. 
AVERAGEIFS  Returns the average of all numbers in a range of cells, based on multiple criteria  Use the x[AVERAGE:y] function to calculate the average for a specified range of values. 
B
Excel function  Excel description  Anaplan solution 
BETA.DIST  Returns the beta distribution.  There is no native Anaplan function. 
BETA.INV  Returns the inverse of the cumulative beta probability density function.  There is no native Anaplan function. 
BETADIST  Returns the cumulative beta probability density function.  There is no native Anaplan function. 
BETAINV  Returns the inverse of the cumulative beta probability density function.  There is no native Anaplan function, but can be built using a calculation. 
BIN2DEC  Converts a binary number to a decimal number.  There is no native Anaplan function, but can be built using a calculation. 
BIN2HEX  Converts a binary number to a hexadecimal number.  There is no native Anaplan function, but can be built using a calculation. 
BIN2OCT  Converts a binary number to an octal number.  There is no native Anaplan function, but can be built using a calculation. 
BINOM.DIST  Returns the individual term binomial distribution probability.  There is no native Anaplan function, but can be built using a calculation. 
BINOM.INV  Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion.  There is no native Anaplan function, but can be built using a calculation. 
BINOMDIST  Returns the individual term binomial distribution probability.  There is no native Anaplan function, but can be built using a calculation. 
C
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 (e.g. contents, formatting, size).  There is no native Anaplan function. 
CHAR  Returns the character based on the ASCII value.  There is no native Anaplan function. 
CHIDIST  Returns the onetailed probability of the chisquared distribution.  There is no native Anaplan function, but can be built using a calculation. 
CHIINV  Returns the inverse of the onetailed probability of the chisquared distribution.  There is no native Anaplan function, but can be built using a calculation. 
CHITEST  Returns the value from the chisquared distribution.  There is no native 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 native 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 native Anaplan function, but can be built using a calculation. 
COMBIN  Returns the number of combinations for a specified number of items.  There is no native 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 native Anaplan function, but can be built using a calculation. 
COMPLEX  Converts coefficients (real and imaginary) into a complex number.  There is no native Anaplan function, but can be built using a calculation. 
CONCAT  Joins two or more strings together.  Use the & operator to concatenates two or more text strings. 
CONCATENATE  Joins two or more strings together. This has been replaced by CONCAT function.  Use the & operator to concatenates two or more text strings. 
CONCATENATE with &  Joins two or more strings together using the & operator.  Use the & operator to concatenates 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 listformatted line item, a time periodformatted item, or property from the source with a dimension of the target line item. 
COS  Returns the cosine of an angle.  There is no native Anaplan function, but can be built using a calculation. 
COSH  Returns the hyperbolic cosine of a number.  There is no native 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 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.  Combine an IF THEN statement with a SUM function to accomplish the same goal. 
COUNTBLANK  Counts the number of empty cells in a range.  Combine an IF THEN statement with a SUM function to accomplish the same goal. 
COUNTIF  Counts the number of cells in a range, that meets the specified criteria.  Combine an IF THEN statement with a SUM function to accomplish the same goal. 
COUNTIFS  Counts the number of cells in a range, that meets a single or multiple criteria.  Combine an IF THEN statement with a SUM function to accomplish the same goal. 
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 native Anaplan function, but can be built using a calculation. 
D
Excel function  Excel description  Anaplan solution 
DATE  Returns the serial date value for a date.  Use the DATE function to convert numbers yyyy, mm, and dd into a date. The date format depends on your locale. 
DATEDIF  Returns the difference between two date values, based on the interval specified.  Use the DECUMULATE function to calculate the difference in a value in the current period vs previous period. 
DATEVALUE  Returns the serial number of a date.  Use Date Settings. 
DAVERAGE  Averages all numbers in a column in a list or database, based on specified criteria.  Use the AVERAGE summary method. 
DAY  Returns the day of the month (a number from 1 to 31) given a date value.  Use the DAY function to convert a date into a day in number format. The date format depends on your locale. 
DAYS  Returns the number of days between two dates.  Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period. 
DAYS360  Returns the number of days between two dates based on a 360day year.  Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period. 
DB  Returns the depreciation of an asset based on the fixeddeclining balance method.  See the Financial Functions. 
DCOUNT  Returns the number of cells in a column or database that contains numeric values and meets a given criteria.  Use the SUM function. 
DCOUNTA  Returns the number of cells in a column or database that contains nonblank values and meets a given criteria.  Use the SUM function. 
DDB  Returns the depreciation of an asset based on the doubledeclining balance method.  See Financial Functions. 
DEGREES  Converts radians into degrees.  There is no native Anaplan function, but can be built using a calculation. 
DGET  Retrieves from a database a single record that matches a given criteria.  Use the ITEM function. 
DMAX  Returns the largest number in a column in a list or database, based on the specified criteria.  Use the x[MAX:y] function. 
DMIN  Returns the smallest number in a column in a list or database, based on the specified criteria.  Use the x[MIN:y] function. 
DOLLAR  Converts a number to text, using a currency format.  There is no native Anaplan function, but can be built using a calculation. 
DPRODUCT  Returns the product of the numbers in a column in a list or database, based on the specified criteria.  There is no native Anaplan function, but can be built using a calculation. 
DSTDEV  Returns the standard deviation of a population based on a sample of numbers.  There is no native Anaplan function, but can be built using a calculation. 
DSTDEVP  Returns the standard deviation of a population based on the entire population of numbers.  There is no native Anaplan function, but can be built using a calculation. 
DSUM  Sums the numbers in a column or database that meets the specified criteria.  Use the SUM function. 
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.  Use the DURATION function. 
DVAR  Returns the variance of a population based on a sample of numbers.  Use the SELECT and COLLECT functions with line items to calculate the variance. 
DVARP  Returns the variance of a population based on the entire population of numbers.  Use the SELECT and COLLECT functions with line items to calculate the variance. 
E
Excel function  Excel description  Anaplan solution 
EDATE  Adds a specified number of months to a date and returns the result as a serial date.  Use the OFFSET function to return 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.  Use the END function. 
ERROR.TYPE  Returns the numeric representation of an Excel error.  There is no native Anaplan function, but can be built using a calculation. 
EVEN  Rounds a number up to the nearest even integer.  There is no native Anaplan function, but can be built using a calculation. 
EXACT  Compares two strings and returns TRUE if both values are the same.  Use the COMPARE function to compares text values. The result is 0 if they match, 1 or 1 if not matched. 
EXP  Returns e raised to the nth power.  Use the EXP function. 
F
Excel function  Excel description  Anaplan solution 
FACT  Returns the factorial of a number.  There is no native Anaplan function, but can be built using a calculation. 
FALSE  Returns a logical value of FALSE.  Use a boolean argument. 
FIND  Returns the location of a substring in a string (casesensitive).  Use the FIND function to look for a text string in a textformatted item, starting at a specified character number. The 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.  Use the VALUE function to convert a numeric value in a text field to a number format. 
FLOOR  Returns a number rounded down based on a multiple of significance.  There is no native Anaplan function, but can be built using a calculation. 
FORECAST  Returns a prediction of a future value based on existing values provided.  Use the FV function. 
FREQUENCY  Returns how often values occur within a set of data. It returns a vertical array of numbers.  There is no native Anaplan function, but can be built using a calculation. 
FV  Returns the future value of an investment.  Use the FV function. 
G
Excel function  Excel description  Anaplan solution 
GROWTH  Returns the predicted exponential growth based on existing values provided.  Use the EXP function to distribute along the timeline. 
H
Excel function  Excel description  Anaplan solution 
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.  Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a listformatted line item, a time periodformatted 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.  There is no native Anaplan function, but can be built using a calculation. 
HYPERLINK  Creates a shortcut to a file or Internet address.  Use the MAKELINK function to create a clickable URL. 
I
Excel function  Excel description  Anaplan solution 
IF  Returns one value if the condition is TRUE, or another value if the condition is FALSE.  Use an IF THEN ELSE conditional formula. 
IF (more than 7)  Nest more than seven IF functions.  Use an IF THEN ELSE conditional formula. 
IF (up to 7)  Nest up to seven IF functions.  Use an IF THEN ELSE conditional formula. 
IFERROR  Used to return an alternate value if a formula results in an error.  Use an IF THEN ELSE conditional formula. 
IFNA  Used to return an alternate value if a formula results in #N/A error.  Use an IF THEN ELSE conditional formula. 
IFS  Specify multiple IF conditions within a function.  Use an IF THEN ELSE conditional formula. 
INDEX  Returns either the value or the reference to a value from a table or range.  Use the FINDITEM formula to match text to an item in a list, or in a time period list. Matches can be on the item name or code. 
INDIRECT  Returns the reference to a cell based on its string representation.  Use the LOOKUP and TEXT formulas. 
INFO  Returns information about the operating environment.  There is no native Anaplan function, but can be built using a calculation. 
INT  Returns the integer part of a number.  Use module formatting. 
INTERCEPT  Returns the yaxis intersection point of a line using xaxis values and yaxis values.  There is no native Anaplan function, but can be built using a calculation. 
IPMT  Returns the interest payment for an investment.  Use the RATE formula to calculate a per period interest rate. 
IRR  Returns the internal rate of return for a series of cash flows.  Use the IRR function. 
ISBLANK  Checks for blank or null values.  Use the ISBLANK function. 
ISERR  Checks for error values except #N/A.  There is no native Anaplan function, but can be built using a calculation. 
ISERROR  Checks for error values.  There is no native Anaplan function, but can be built using a calculation. 
ISLOGICAL  Checks for a logical value (TRUE or FALSE).  There is no native Anaplan function, but can be built using a calculation. 
ISNA  Checks for #N/A error values.  There is no native Anaplan function, but can be built using a calculation. 
ISNONTEXT  Checks for a value that is not text.  There is no native Anaplan function, but can be built using a calculation. 
ISNUMBER  Checks for a numeric value.  There is no native Anaplan function, but can be built using a calculation. 
ISOWEEKNUM  Returns the ISO week number for a date.  There is no native Anaplan function. Use the internal time structure in Anaplan. 
ISPMT  Returns the interest payment for an investment.  Use the RATE function to calculate a per period interest rate. 
ISREF  Checks for a reference.  There is no native Anaplan function, but can be built using a calculation. 
ISTEXT  Checks for a text value.  There is no native Anaplan function, but can be built using a calculation. 
L
Excel function  Excel description  Anaplan solution 
LARGE  Returns the nth largest value from a set of values.  There is no native Anaplan function, but can be built using a calculation. 
LEFT  Extract a substring from a string, starting from the leftmost character.  Use the LEFT function. 
LEN  Returns the length of the specified string.  Use the LENGTH function to return 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.  There is no native Anaplan function, but can be built using a calculation. 
LN  Returns the natural logarithm of a number.  Use the LN formula to return the natural logarithm of a number, based on the constant e. 
LOG  Returns the logarithm of a number to a specified base.  Use the LOG formula. 
LOG10  Returns the base10 logarithm of a number.  Use the LOG formula to return 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.  Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a listformatted line item, a time periodformatted item, or property from the source with a dimension of the target line item. 
LOWER  Converts all letters in the specified string to lowercase.  Use the LOWER formula. 
M
Excel function  Excel description  Anaplan solution 
MATCH  Searches for a value in an array and returns the relative position of that item.  Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a listformatted line item, a time periodformatted item, or property from the source with a dimension of the target line item. 
MAX  Returns the largest value from the numbers provided.  Use the MAX function. 
MAXA  Returns the largest value from the values provided (numbers, text and logical values).  Use the x[MAX_y] function. 
MDETERM  Returns the matrix determinant of an array.  There is no native Anaplan function, but can be built using a calculation. 
MDURATION  Returns the modified Macaulay duration for a security with an assumed par value of $100.  Use the MDURATION formula. 
MEDIAN  Returns the median of the numbers provided.  There is no native Anaplan function, but can be built using a calculation. 
MID  Extracts a substring from a string starting at any position.  Use the MID formula to extract a substring from a string starting at any character. 
MIN  Returns the smallest value from the numbers provided.  Use the MIN formula to return the minimum of selected line items. 
MINA  Returns the smallest value from the values provided (numbers, text and logical values).  Use the MIN formula to return the minimum of selected line items. 
MINUTE  Returns the minutes (a number from 0 to 59) from a time value.  There is no native Anaplan function, but can be built using a calculation. 
MINVERSE  Returns the inverse matrix for a given matrix.  There is no native Anaplan function, but can be built using a calculation. 
MIRR  Returns the modified internal rate of return for a series of cash flows.  Use the IRR formula. 
MMULT  Returns the matrix product of two arrays.  There is no native Anaplan function, but can be built using a 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.  Use the MONTH formula to convert a date or a time period to a calendar month as a number. 
N
Excel function  Excel description  Anaplan solution 
N  Converts a value to a number.  Use the VALUE function. 
NA  Returns the #N/A error value.  There is no native Anaplan function. 
NETWORKDAYS  Returns the number of work days between two dates, excluding weekends and holidays.  There is no native Anaplan function, but can be built using a calculation. 
NETWORKDAYS.INTL  Returns the number of work days between two dates, excluding weekends and holidays.  This is supported by the Anaplan settings. 
NOT  Returns the reversed logical value.  Use operators and constants to create calculations and find the data you need. 
NOW  Returns the current system date and time.  There is no native Anaplan function, but this can be built by creating a module called Today with one date formatted line item that is selected when required. 
NPER  Returns the number of periods for an investment.  Use the NPER function. 
NPV  Returns the net present value of an investment.  Use the NPV function. 
O
Excel function  Excel description  Anaplan solution 
ODD  Rounds a number up to the nearest odd integer.  There is no native Anaplan function, this can be built using a ROUND calculation. 
OFFSET  Returns a reference to a range that is offset a number of rows and columns.  There is no native Anaplan function, but can be built using a calculation. 
OR  Returns TRUE if any of the conditions are TRUE  Use operators and constants with your data to create calculations and find the data you need. 
P
Excel function  Excel description  Anaplan solution 
PERCENTILE  Returns the nth percentile from a set of values.  There is no native Anaplan function, but can be built by using a calculation. 
PERCENTRANK  Returns the rank of a value in a set of values as a percentage of the set.  There is no native Anaplan function, but can be built by using a calculation.

PERMUT  Returns the number of permutations for a specified number of items.  Use the POWER function for permutations where repetition is allowed, where:

PI  Returns the mathematical constant called pi.  There is no native Anaplan function, but can be built by using a calculation. 
PMT  Returns the payment amount for a loan.  Use the PMT formula to take a date as a parameter and return a time period as a result. 
POWER  Returns the result of a number raised to a given power.  Use the POWER function. 
PPMT  Returns the payment on the principal for a particular payment.  See the Financial Functions. 
PRICE  Returns the price per $100 face value of a security that pays periodic interest.  Use the PRICE function. 
PRODUCT  Multiplies the numbers and returns the product.  Use an intermediate line item with the summary as the product. 
PROPER  Sets the first character in each word to uppercase and the rest to lowercase.  There is no native Anaplan function, but this can be achieved through a formula. 
PV  Returns the present value of an investment.  Use the PV function to calculate the present value of future cash flows. 
Q
Excel function  Excel description  Anaplan solution 
QUARTILE  Returns the quartile from a set of values.  There is no native Anaplan function, but can be built using a calculation. 
R
Excel function  Excel description  Anaplan solution 
RADIANS  Converts degrees into radians.  There is no native Anaplan function, but can be built using a calculation. 
RAND  Returns a random number that is greater than or equal to 0 and less than 1.  There is no native Anaplan function, but can be built using a calculation. 
RANDBETWEEN  Returns a random number that is between a bottom and top range.  There is no native Anaplan function, but can be built using a calculation. 
RANK  Returns the rank of a number within a set of numbers  Use the RANK function to order a set of values, and assign rankings from 1 to a specified ending rank. 
RATE  Returns the interest rate for an annuity.  Use the RATE function to calculate a per period interest rate. 
REPLACE  Replaces a sequence of characters in a string with another set of characters.  Use the FIND, LEN, LEFT, RIGHT, or & function. 
REPT  Returns a repeated text value a specified number of times.  There is no native Anaplan function, but can be built using a calculation. 
RIGHT  Extracts a substring from a string starting from the rightmost character.  Use the RIGHT function. 
ROMAN  Converts a number to a roman numeral.  There is no native Anaplan function, but can be built using a calculation. 
ROUND  Returns a number rounded to a specified number of digits.  Use the ROUND function. 
ROUNDDOWN  Returns a number rounded down to a specified number of digits.  Use the ROUND function. 
ROUNDUP  Returns a number rounded up to a specified number of digits  Use the ROUND function. 
ROW  Returns the row number of a cell reference.  Use the ITEM function. 
ROWS  Returns the number of rows in a cell reference.  There is no native Anaplan function, but can be built using a calculation. 
S
Excel function  Excel description  Anaplan solution 
SEARCH  Returns the location of a substring in a string.  Use the FIND formula to look for a text string in a text formatted item, starting at a specified character number. The result is a number that denotes the character position. 
SECOND  Returns the seconds (a number from 0 to 59) from a time value.  There is no native Anaplan function, but can be built using a calculation. 
SIGN  Returns the sign of a number.  Use the SIGN function. The result is 1 if the value is negative, 1 if positive, or 0 if zero. 
SIN  Returns the sine of an angle.  There is no native Anaplan function, but can be built using a calculation. 
SINH  Returns the hyperbolic sine of a number.  There is no native Anaplan function, but can be built using a calculation. 
SLN  Returns the depreciation of an asset based on the straight line depreciation method.  Use the SPREAD function. 
SLOPE  Returns the slope of a regression line based on the data points identified by known_y_values and known_x_values.  There is no native Anaplan function, but can be built using a calculation. 
SMALL  Returns the n^{th} smallest value from a set of values.  There is no native Anaplan function, but can be built using a calculation. 
SQRT  Returns the square root of a number.  Use the SQRT function. 
STDEV  Returns the standard deviation of a population based on a sample of numbers.  There is no native Anaplan function, but can be built using a calculation. 
STDEVA  Returns the standard deviation of a population based on a sample of numbers, text, and logical values.  There is no native Anaplan function, but can be built using a calculation. 
STDEVP  Returns the standard deviation of a population based on an entire population of numbers.  There is no native Anaplan function, but can be built using a calculation. 
STDEVPA  Returns the standard deviation of a population based on an entire population of numbers, text, and logical values.  There is no native Anaplan function, but can be built using a calculation. 
SUBSTITUTE  Replaces a set of characters with another.  Use the FIND, LEN, or & function. 
SUBTOTAL  Returns the subtotal of the numbers in a column in a list or database.  Use the SUM & SELECT function to select an item from one or more of the hierarchy lists, and sum the values based on a listformatted line item or property in the source that matches a dimension in the target. 
SUM  Adds all numbers in a range of cells.  Use the SUM function to sum 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 an intermediate module. Configure the rows as criteria, and columns as line items that SUM criteria. 
SUMIFS  Adds all numbers in a range of cells, based on a single or multiple criteria.  Create an intermediate module. Configure the rows as criteria, and columns as line items that SUM criteria. 
SUMPRODUCT  Multiplies the corresponding items in the arrays and returns the sum of the results.  There is no native Anaplan function, but can be built using a calculation. 
SUMSQ  Returns the sum of the squares of a series of values.  Use the POWER function with SUM. 
SUMX2MY2  Returns the sum of the difference of squares between two arrays.  There is no native Anaplan function, but can be built using a calculation. 
SUMX2PY2  Returns the sum of the squares of corresponding items in the arrays.  There is no native Anaplan function, but can be built using a calculation. 
SUMXMY2  Returns the sum of the squares of the differences between corresponding items in the arrays.  There is no native Anaplan function, but can be built using a calculation. 
SYD  Returns the depreciation of an asset based on the sumofyears digits depreciation method.  There is no native Anaplan function, but can be built using a calculation. 
T
Excel function  Excel description  Anaplan solution 
T  Returns the text referred to by a value.  Use the TEXT function to convert a numeric value to text. 
TAN  Returns the tangent of an angle.  There is no native Anaplan function, but can be built using a calculation. 
TANH  Returns the hyperbolic tangent of a number.  There is no native Anaplan function, but can be built using a calculation. 
TEXT  Returns a value converted to text with a specified format.  Use the TEXT function to convert a numeric value to text. 
TEXTJOIN  Used to join two or more strings together separated by a delimiter.  Use the & function to concatenate two or more text strings. 
TIME  Returns a decimal number given an hour, minute, and second value.  There is no native Anaplan function, but can be built using a calculation. 
TIMEVALUE  Returns the serial number of a time.  There is no native Anaplan function, but can be built using a calculation. 
TODAY  Returns the current system date.  There is no native Anaplan function, but the date can be imported. 
TRANSPOSE  Returns a transposed range of cells.  Create a module with a pivoted view. 
TRIM  Returns a text value with the leading and trailing spaces removed.  Use the LEN, LEFT, or RIGHT formulas. 
TRUE  Returns a logical value of TRUE.  Use a boolean argument. 
TRUNC  Returns a number truncated to a specified number of digits.  Use the module formatting functionality. 
TYPE  Returns the type of a value.  There is no native Anaplan function. 
U
Excel function  Excel description  Anaplan solution 
UPPER  Convert text to all uppercase.  Use the UPPER function. 
V
Excel function  Excel description  Anaplan solution 
VALUE  Converts a text value that represents a number to a number.  Use the VALUE formula to convert a numeric value in a text field to a number format. 
VAR  Returns the variance of a population based on a sample of numbers.  Use the SELECT and COLLECT formulas with line items to calculate the variance. 
VARA  Returns the variance of a population based on a sample of numbers, text, and logical values.  Use the SELECT and COLLECT formulas with line items to calculate the variance. 
VARP  Returns the variance of a population based on an entire population of numbers.  Use the SELECT and COLLECT formulas with line items to calculate the variance. 
VARPA  Returns the variance of a population based on an entire population of numbers, text, and logical values.  Use the SELECT and COLLECT formulas with line items to calculate the variance. 
VDB  Returns the depreciation of an asset based on a variable declining balance depreciation method.  See the Financial Functions. 
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.  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, a time period formatted item, or property from the source with a dimension of the target line item. 
W
Excel function  Excel description  Anaplan solution 
WEEKDAY  Returns a number representing the day of the week, given a date value.  Use the WEEKDAY formula to take a date and return a number from 1 to 7 for the day of the week. An optional Type parameter can be used to set the start day for the day of the week count. 
WEEKNUM  Returns the week number for a date.  There is no native Anaplan function, but can be built using a calculation. 
WORKDAY  Adds a specified number of work days to a date, and returns the result as a serial date.  There is no native Anaplan function, but can be built using a calculation. 
WORKDAY.INTL  Adds a specified number of work days to a date, and returns the result as a serial date (customizable weekends).  There is no native Anaplan function, but can be built using a calculation. 
X
Excel function  Excel description  Anaplan solution 
XIRR  Returns the internal rate of return for a series of cash flows that may not be periodic.  See the Financial Functions. 
Y
Excel function  Excel description  Anaplan solution 
YEAR  Returns a fourdigit year (a number from 1900 to 9999) given a date value.  Use the YEAR function to convert a date or a time period to a year in a 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).  Use the YEARFRAC function. 
YIELD  Returns the yield on a security that pays periodic interest.  Use the YIELD function. 