Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.

 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 nth 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: List-formatted line item 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 line item Time period formatted line item 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 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 sum-of-years digits depreciation method. There is no equivalent Anaplan function, but can be built using a calculation.