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