Office.com results
SUMSQ
Article Returns the sum of the squares of the arguments. Syntax SUMSQ ( number1 ,number2, ...) Number1, number2, ...   are 1 to 30 arguments for which you want the sum...
Excel 2003
SUMX2MY2
Article Returns the sum of the difference of squares of corresponding values in two arrays. Syntax SUMX2MY2 ( array_x , array_y ) Array_x   is the first array or range ...
Excel 2003
SUMX2PY2
Article Returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations. Sy...
Excel 2003
FLOOR
Article Rounds number down, toward zero, to the nearest multiple of significance. Syntax FLOOR ( number , significance ) Number   is the numeric value you want to round...
Excel 2003
ATAN
Article Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number . The returned angle is given in radians in the ra...
Excel 2003
ATANH
Article Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hype...
Excel 2003
ATAN2
Article Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (...
Excel 2003
FACTDOUBLE
Article Returns the double factorial of a number. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? On...
Excel 2003
ASIN
Article Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number . The returned angle is given in radians in the range -pi/2 to...
Excel 2003
ASINH
Article Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number , so ASINH(SINH(number)) equals numb...
Excel 2003
MROUND
Article Returns a number rounded to the desired multiple. If this function is not available, and returns the #NAME? error , install and load the Analysis ToolPak ad...
Excel 2003
MULTINOMIAL
Article Returns the ratio of the factorial of a sum of values to the product of factorials. If this function is not available, and returns the #NAME? error, install and...
Excel 2003
EXP
Article Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax EXP ( number ) Number   is the expone...
Excel 2003
EVEN
Article Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts ro...
Excel 2003
ACOS
Article Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number . The returned angle is given in radians in the range ...
Excel 2003
FACT
Article Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.
Excel 2003
MOD
Article Returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax MOD ( number , divisor ) Number   is the number for wh...
Excel 2003
ACOSH
Article Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine...
Excel 2003
MMULT
Article Show All Hide All Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as arra...
Excel 2003
ABS
Article Returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax ABS ( number ) Number   is the real number of whic...
Excel 2003
MINVERSE
Article Returns the inverse matrix for the matrix stored in an array. Syntax MINVERSE ( array ) Array   is a numeric array with an equal number of rows and columns. Rem...
Excel 2003
SQRTPI
Article Returns the square root of (number * pi). If this function is not available, and returns the #NAME? error , install and load the Analysis ToolPak add-in. Ho...
Excel 2003
MDETERM
Article Returns the matrix determinant of an array. Syntax MDETERM ( array ) Array   is a numeric array with an equal number of rows and columns. Remarks Array can be g...
Excel 2003
SQRT
Article Returns a positive square root. Syntax SQRT ( number ) Number   is the number for which you want the square root. Remark If number is negative, SQRT returns the...
Excel 2003
LOG
Article Returns the logarithm of a number to the base you specify. Syntax LOG ( number ,base) Number   is the positive real number for which you want the logarithm. Bas...
Excel 2003
PREVNEXT
Didn't find what you were looking for?Search all of Office.com