|
SUMIF | Adds the cells in a supplied range, that satisfy a given criteria |
SUMIFS | Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) |
|
|
SUMPRODUCT | Returns the sum of the products of corresponding values in two or more supplied arrays |
SUMSQ | Returns the sum of the squares of a supplied list of numbers |
SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two supplied arrays |
SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two supplied arrays |
SUMXMY2 | Returns the sum of squares of differences of corresponding values in two supplied arrays |
SERIESSUM | Returns the sum of a power series |
|
|
PI | Returns the constant value of pi |
SQRTPI | Returns the square root of a supplied number multiplied by pi |
DEGREES | Converts Radians to Degrees |
RADIANS | Converts Degrees to Radians |
COS | Returns the Cosine of a given angle |
ACOS | Returns the Arccosine of a number |
COSH | Returns the hyperbolic cosine of a number |
ACOSH | Returns the inverse hyperbolic cosine of a number |
SEC | Returns the secant of an angle (New in Excel 2013) |
SECH | Returns the hyperbolic secant of an angle (New in Excel 2013) |
SIN | Returns the Sine of a given angle |
ASIN | Returns the Arcsine of a number |
SINH | Returns the Hyperbolic Sine of a number |
ASINH | Returns the Inverse Hyperbolic Sine of a number |
CSC | Returns the cosecant of an angle (New in Excel 2013) |
CSCH | Returns the hyperbolic cosecant of an angle (New in Excel 2013) |
TAN | Returns the Tangent of a given angle |
ATAN | Returns the Arctangent of a given number |
ATAN2 | Returns the Arctangent of a given pair of x and y coordinates |
TANH | Returns the Hyperbolic Tangent of a given number |
ATANH | Returns the Inverse Hyperbolic Tangent of a given number |
COT | Returns the cotangent of an angle (New in Excel 2013) |
COTH | Returns the hyperbolic cotangent of an angle (New in Excel 2013) |
ACOT | Returns the arccotangent of a number (New in Excel 2013) |
ACOTH | Returns the hyperbolic arccotangent of a number (New in Excel 2013) |
|
|
EXP | Returns e raised to a given power |
LN | Returns the natural logarithm of a given number |
LOG | Returns the logarithm of a given number, to a specified base |
LOG10 | Returns the base 10 logarithm of a given number |
|
|
FACT | Returns the Factorial of a given number |
FACTDOUBLE | Returns the Double Factorial of a given number |
MULTINOMIAL | Returns the Multinomial of a given set of numbers |
|
|
BASE | Converts a number into a text representation, with the supplied base (New in Excel 2013) |
DECIMAL | Converts a text representation of a number in a specified base into a decimal number (New in Excel 2013) |
COMBIN | Returns the number of combinations (without repititions) for a given number of objects |
COMBINA | Returns the number of combinations (with repetitions) for a given number of items (New in Excel 2013) |
ARABIC | Converts a Roman numeral to an Arabic numeral (New in Excel 2013) |
ROMAN | Returns a text string depicting the roman numeral for a given number |