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. All cells hidden by filter are always excluded. Eg., 1 range: The range that you want the subtotal for. Eg., ...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 ...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) ...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 ...Next page
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?