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...

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 ...

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...

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...

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...

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...

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 (...

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...

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...

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...

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...

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...

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...

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...

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 ...

Article Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.

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...

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...

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...

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...

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...

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...

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...

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...

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...