Mathematical
SECH
Returns the hyperbolic secant of the given angle, in radians. Syntax SECH(angle) angle - The angle in radians that you want to calculate the hyperbolic secant of. Eg., 0.3 Remarks If the input angle is in degrees, multiply it by PI()/180 to get the ...
SEC
Returns the secant of the given angle, in radians. Syntax SEC(angle) angle - The angle in radians that you want to calculate the secant of. Eg., 0.3 Remarks If the input angle is in degrees, multiply it by PI()/180 to get the value in radians. The ...
CSCH
Returns the hyperbolic cosecant of the given angle, in radians. Syntax CSCH(angle) angle - The angle whose hyperbolic cosecant you want to calculate. Eg., 0.3 Remarks The input value must be less than 2^27. Examples Formula Result =CSCH(0.3) ...
CSC
Returns the cosecant of the given angle, in radians. Syntax CSC(angle) angle - The angle whose cosecant you want to calculate. Eg., 0.3 Remarks CSC(angle) equals 1/SIN(angle) The input value must be less than 2^27. Examples Formula Result =CSC(0.3) ...
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. Eg., ...
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 of the ...
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 Result ...
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. E.g. ...
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 Get a ...
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 or ...
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 Examples ...
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 array. ...
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 omitted. ...
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) 0.462117157 Get a ...
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(). Examples ...
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 returns the ...
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 test ...
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 SQRT(A1) ...
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 example., ...
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 returned 1 2 3 4 5 6 7 8 9 ...
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 function. ...
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 Get a ...
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 Get a hands-on ...
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 want ...
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 Result ...
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) 2.446 ...
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 time a ...
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 -0.511866389 ...
RADIANS
Converts the given angle from degrees to radians. Syntax RADIANS(degrees) degrees: The angle you want to convert from degrees to radians. Eg., 30 Examples Formula Result =RADIANS(30) 0.523598776 =RADIANS(-180) -3.141592654 =RADIANS(360) 6.283185307 ...
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 divide ...
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 the ...
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 embedded ...
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 the ...
Next page