Comparisons of Microsoft Excel functions to those available in Anaplan.

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

A B C D E F G H I L M N O P Q R S T U V W X Y

Excel functionExcel descriptionAnaplan solution
SEARCHReturns 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.
SECONDReturns 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.
SIGNReturns 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.
SINReturns the sine of an angle.There is no equivalent Anaplan function, but can be built using a calculation.
SINHReturns the hyperbolic sine of a number.There is no equivalent Anaplan function, but can be built using a calculation.
SLNReturns the depreciation of an asset based on the straight line depreciation method.Use the SPREAD function.
SLOPEReturns 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.
SMALLReturns the nth smallest value from a set of values.There is no equivalent Anaplan function, but can be built using a calculation.
SQRTReturns the square root of a number.Use the SQRT function.
STDEVReturns 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.
STDEVAReturns 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.
STDEVPReturns 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.
STDEVPAReturns 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.
SUBSTITUTEReplaces a set of characters with another.Use the FINDLENGTH, and & function.
SUBTOTALReturns 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.
SUMAdds 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.
SUMIFAdds 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.
SUMIFSAdds 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.
SUMPRODUCTMultiplies 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.
SUMSQReturns the sum of the squares of a series of values.Use the POWER function with SUM.
SUMX2MY2Returns the sum of the difference of squares between two arrays.There is no equivalent Anaplan function, but can be built using a calculation.
SUMX2PY2Returns the sum of the squares of corresponding items in the arrays.There is no equivalent Anaplan function, but can be built using a calculation.
SUMXMY2Returns 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.
SYDReturns 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.