Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| STDEVP | Compatibility |
 |
Calculates standard deviation based on the entire population |
| STDEVPA | Statistical |
|
Calculates standard deviation based on the entire population, including numbers, text, and logical values |
| STEYX | Statistical |
|
Returns the standard error of the predicted y-value for each x in the regression |
| SUBSTITUTE | Text |
|
Substitutes new text for old text in a text string |
| SUBTOTAL | Math and trigonometry |
|
Returns a subtotal in a list or database |
| SUM | Math and trigonometry |
|
Adds its arguments |
| SUMIF | Math and trigonometry |
|
Adds the cells specified by a given criteria |
| SUMIFS | Math and trigonometry |
|
Adds the cells in a range that meet multiple criteria |
| SUMPRODUCT | Math and trigonometry |
|
Returns the sum of the products of corresponding array components |
| SUMSQ | Math and trigonometry |
|
Returns the sum of the squares of the arguments |
| SUMX2MY2 | Math and trigonometry |
|
Returns the sum of the difference of squares of corresponding values in two arrays |
| SUMX2PY2 | Math and trigonometry |
|
Returns the sum of the sum of squares of corresponding values in two arrays |
| SUMXMY2 | Math and trigonometry |
|
Returns the sum of squares of differences of corresponding values in two arrays |
| SWITCH | Logical |
|
Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. |
| SYD | Financial |
|
Returns the sum-of-years' digits depreciation of an asset for a specified period |
| T | Text |
|
Converts its arguments to text |
| T.DIST | Statistical |
|
Returns the Percentage Points (probability) for the Student t-distribution |
| T.DIST.2T | Statistical |
|
Returns the Percentage Points (probability) for the Student t-distribution |
| T.DIST.RT | Statistical |
|
Returns the Student's t-distribution |
| T.INV | Statistical |
|
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom |
