• # Mathematical

• ## AGGREGATE

Allows execution of functions from the given list, and selectively ignores the hidden rows and errors in the range.   Syntax   AGGREGATE(function; option; range1; [range2]) function: A number specifying the function to perform. Ranges from 1 to 19. ...
• ## TRANSPOSE

Returns an array with its rows and columns transposed.   Syntax   TRANSPOSE(array) array: The array or range that you want to swap the rows and columns of. E.g. A1:A5   Examples   Formula =TRANSPOSE(A1:A5) =TRANSPOSE(A1:B5) Get a hands-on experience ...
• ## SUMXMY2

Returns the sum of squares of the differences between the corresponding elements in the two given arrays.   Syntax   SUMXMY2(x; y) x: The first array or range containing the values. E.g. A2:A5 y: The second array or range containing the values. E.g. ...
• ## SUMX2PY2

Returns the sum of the squares of all the elements in two given arrays.   Syntax   SUMX2PY2(x; y) x: The first array or range containing the values. E.g. A2:A5 y: The second array or range containing the values. E.g. B2:B5   Examples     Formula ...
• ## SUMX2MY2

Returns the sum of the differences between the squares of the corresponding elements in the two given arrays.   Syntax   SUMX2MY2(x; y) x: The first array or range containing the values. E.g. A2:A5 y: The second array or range containing the values. ...
• ## SUMPRODUCT

Returns the sum of the products of the corresponding elements in the given arrays.   Syntax   SUMPRODUCT(array; [array1]; ... ) array: The arrays, of the same size, given as input. E.g. B2:B5   Remarks The given input arrays must be of the same size. ...
• ## MUNIT

Returns a unit (identity) matrix of a given size.   Syntax   MUNIT(size) size: Integer specifying the size of the unit matrix to return. Must be greater than zero. E.g. 3   Examples       Formula Result =MUNIT(3) 1 0 0 0 1 0 0 0 1 =MUNIT(2) 1 0 0 1   ...
• ## MMULT

Returns the product of two matrices given as arrays or ranges. Returns an array with an equal number of rows as array1 and an equal number of columns as array2.   Syntax   MMULT(array1; array2) array1: The first matrix to multiply given as an array ...
• ## MINVERSE

Returns the inverse of a given square matrix. Note that a matrix only has an inverse if its determinant is not zero.   Syntax   MINVERSE(array) array: The numerical array or range containing the numbers that form a square matrix. E.g. A2:B3   ...
• ## MDETERM

Returns the matrix determinant of a given array.   Syntax   MDETERM(array) array: The numerical array or range containing the numbers that form a square matrix. E.g. A2:B3   Examples   Formula Result =MDETERM(A2:B3) 3 =MDETERM(A2:C4) 6 Get a hands-on ...
• ## RANDARRAY

Returns an array of random values in the given cell range. The minimum, maximum and type of values to be returned can also be specified.   Syntax   RANDARRAY([row]; [column]; [min]; [max]; [type]) row: Number of rows to be filled with the random ...
• ## TRUNC

Truncates a given number to a specified number of places by removing certain decimal digits.   Syntax   TRUNC(number; [places]) number: The number you want to shorten. Eg., 0.2453 places: The number of decimal digits to retain. Defaults to 0 if ...
• ## TANH

Returns the hyperbolic tangent of a number.   Syntax   TANH(number) number: The number that you want to calculate the hyperbolic tangent of. Eg., 0.3   Examples       Formula Result =TANH(0.3) 0.291312612 =TANH(-0.9) -0.71629787 =TANH(1/2) ...
• ## TAN

Returns the tangent of the given angle in radians.   Syntax   TAN(angle) angle: The angle in radians that you want to calculate the tangent of. Eg., 0.3   Remarks To return the angle in degrees, use the DEGREES function or multiply it by 180/PI(). ...
• ## SUMSQ

Returns the sum of the squares of the series of given numbers.   Syntax   SUMSQ(number1; number2; ...) number: The numbers or ranges containing the numbers given as input. Eg., 2   Remarks When only one number is given as input, SUMSQ function ...
• ## SUMIFS

Returns the sum of the given numbers based on specified conditions.   Syntax   SUMIFS(sum_range; test_range; condition; [test_range1]; [condition1];...) sum_range: The range containing the values to add. Eg., B2:B8 test_range: The ranges you want to ...
• ## SUMIF

Returns the sum of the given numbers based on a specified condition.   Syntax   SUMIF(test_range; condition; sum_range) test_range: The range to test. Eg., A2:A8 condition: The condition may be: A number, such as 15 An expression, such as 2/3 or ...
• ## SUM

Returns the sum of all the given numbers or arguments.   Syntax   SUM(number1; number2; ...) number: The numbers you want to calculate the sum of. Eg. 23   Remarks The operator "+" can be used instead of the SUM function to multiply numbers. For ...
• ## SUBTOTAL

Returns the subtotal of a given range of data.   Syntax   SUBTOTAL(function; range) function: Number that specifies the function to calculate. Eg., 1 range: The range that you want the subtotal for. Eg., D2:D8 function function Function returned 1 ...
• ## SQRTPI

Returns the positive square root of the product of pi and the given number.   Syntax   SQRTPI(number) number: The number given as input. Must be positive. Eg., 25   Remarks To convert the given number into a positive integer, you can use the ABS ...
• ## SQRT

Returns the positive square root of the given number.   Syntax   SQRT(number) number: The number that you want the square root of. Must be positive. Eg., 25   Remarks To convert the given number into a positive integer, you can use the ABS function. ...
• ## SINH

Returns the hyperbolic sine of the given number.   Syntax   SINH(number) number: The number you want to calculate the hyperbolic sine of. Eg., 0.3   Examples       Formula Result =SINH(0.3) 0.304520293 =SINH(-0.9) -1.026516726 =SINH(1/2) 0.521095305 ...
• ## SIN

Returns the sine of the given angle, in radians.   Syntax   SIN(angle) angle: The angle in radians that you want to calculate the sine of. Eg., 0.3   Remarks If the input angle is in degrees, multiply the it by PI()/180 to get the value in radians. ...
• ## SIGN

Returns the sign of a number. Returns 1 if the number is positive, -1 if negative, and 0 if zero.   Syntax   SIGN(number) number: The number whose sign you want to find. Eg., 23   Examples       Formula Result =SIGN(23) 1 =SIGN(-3.2) -1 =SIGN(0) 0 ...
• ## SERIESSUM

Returns the sum of the power series based on the given parameters,  i.e. SERIES(x; n; m; a) = a 1 x n +a 2 x (n+m) +...+a i x (n+(i-1)m) .   Syntax   SERIESSUM(x; n; m; a) x: The input value to the power series. Eg., A3 n: The initial power that you ...
• ## ROUNDUP

Rounds a decimal number up, away from zero, to a specified decimal digits.   Syntax   ROUNDUP(number; places) number: The number you want to round up. Eg., 2.4456 places: The number of decimal digits to return. Eg., 3   Examples       Formula Result ...
• ## ROUNDDOWN

Rounds a decimal number down, toward zero, to a specified decimal digits.   Syntax   ROUNDDOWN(number; places) number: The number you want to round down. Eg., 2.4456 places: The number of decimal digits to return. Eg., 3   Examples       Formula ...
• ## ROUND

Rounds a decimal number to a specified decimal digits.   Syntax   ROUND(number; places) number: The number you want to round up. Eg., 2.4456 places: The number of decimal digits to return. Eg., 3   Examples       Formula Result =ROUND(2.445631;3) ...
• ## RANDBETWEEN

Returns an integer random number within a specified range.   Syntax   RANDBETWEEN(bottom; top) bottom: The minimum value in the given range. Eg., 100 top: The maximum value in the given range. Eg., 1000   Remarks The result values will change every ...
• ## RAND

Returns a random number between 0, inclusive, and 1, exclusive.   Syntax   RAND()   Remarks The result values will change every time a function is recalculated. Examples     Formula Result =RAND() 0.193414553 =RAND()+400 400.114774963 =RAND()*-2 ...

• ## QUOTIENT

Returns the result of one number divided by another number, without the remainder.   Syntax   QUOTIENT(numerator; denominator) numerator: The number to divide. Eg., 3 denominator: The number you want to divide the numerator by. Eg., 2   Remarks To ...
• ## PRODUCT

Multiplies all the given numbers or arguments.   Syntax   PRODUCT(number1; number2; ...) number: The numbers whose product you want to calculate. Eg., 2   Remarks The operator "*" can be used instead of the PRODUCT function to multiply numbers. Eg., ...
• ## POWER

Returns a number raised to a given power.   Syntax   POWER(number; power) number: The number you want to raise to a given power. Eg., 2 power: The exponent that you want to raise the number to. Eg., 3 Remarks The operator "^" can be used instead of ...
• ## PI

Returns the value of Pi, up to 9 decimal places.   Syntax   PI()   Remarks The value of PI() is  3.14159265358979 Examples       Formula Result =PI() 3.141592654 =PI()/2 1.570796327 =3+PI() 6.141592654 Get a hands-on experience of the function in the ...
• ## ODD

Rounds up a given number to the next odd integer, away from zero.   Syntax   ODD(number) number: The number you want to round up to the next odd integer. Eg., 2.33   Remarks The ODD function rounds up the given number away from zero, irrespective of ...
• ## MULTINOMIAL

Returns the factorial of the sum of given numbers divided by the product of the numbers' factorials.   Syntax   MULTINOMIAL (number; [number1; ...]) number: The numbers or range containing the numbers given as input. Eg., 3   Examples      Formula ...
• ## MROUND

Rounds up a given number to a multiple of another number.   Syntax   MROUND(number; mult) number: The number to round up. Eg., 11.3 mult: The multiple that you want to round the given number to. Eg., 2   Examples   Formula Result =MROUND(11.3;2) 12 ...
• ## MOD

Returns the remainder when one integer is divided by another. The result takes the sign of the divisor.   Syntax   MOD(number; divisor) number: The number whose remainder you want to find. Eg., 25 divisor: The number that you want to divide the ...
• ## LOG10

Returns the logarithm to base 10 of the given number. It is the same as LOG function where the base is 10.   Syntax   LOG10(number) number: The positive real number whose base 10 logarithm you want to calculate. Eg., 0.3   Examples     Formula Result ...