Microsoft Office Tutorials and References
In Depth Information
SECH***
Returns the hyperbolic secant of an angle.
SERIESSUM
Returns the sum of a power series based on the formula.
SIGN
Returns the sign of a number.
SIN
Returns the sine of the given angle.
SINH
Returns the hyperbolic sine of a number.
SQRT
Returns a positive square root.
SQRTPI
Returns the square root of Π.
SUBTOTAL
Returns a subtotal in a list or database.
SUM
Adds its arguments.
SUMIF
Adds the cells specified by a given criteria.
SUMIFS*
Adds the cells specified by a multiple criteria.
SUMPRODUCT
Returns the sum of the products of corresponding array components.
SUMSQ
Returns the sum of the squares of the arguments.
Returns the sum of the difference of squares of corresponding values in
two arrays.
SUMX2MY2**
Returns the sum of the sum of squares of corresponding values in two
arrays.
SUMX2PY2**
Returns the sum of squares of differences of corresponding values in
two arrays.
SUMXMY2**
TAN
Returns the tangent of a number.
TANH
Returns the hyperbolic tangent of a number.
TRUNC
Truncates a number (you specify the precision of the truncation).
* Indicates a function introduced in Excel 2007.** Indicates a function introduced in Excel 2010.*** Indicates a function introduced in
Excel 2013.
Table A-11: Statistical Category Functions
Function
What It Does
Search JabSto ::




Custom Search