Comparisons of Microsoft Excel functions to those available in Anaplan.
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 equivalent 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 equivalent Anaplan function, but can be built using a calculation. 
SINH  Returns the hyperbolic sine of a number.  There is no equivalent 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 equivalent Anaplan function, but can be built using a calculation. 
SMALL  Returns the n^{th} smallest value from a set of values.  There is no equivalent 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 equivalent 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 equivalent 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 equivalent 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 equivalent Anaplan function, but can be built using a calculation. 
SUBSTITUTE  Replaces a set of characters with another.  Use the FIND, LENGTH, and & function. 
SUBTOTAL  Returns the subtotal of the numbers in a column in a list or database.  Use the SUM & SELECT functions to select an item from one or more hierarchy list. With this, you can sum the values, based on a:

SUM  Adds all numbers in a range of cells.  Use the SUM function to sum values based on a:

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 calculated values, 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 equivalent 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 equivalent 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 equivalent 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 equivalent 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 equivalent Anaplan function, but can be built using a calculation. 
Disclaimer
We update Anapedia content regularly to provide the most uptodate instructions.