### Math and trigonometry functions

How to use the LET function

How to use the ROUND function

What is the ROUND function? The ROUND function calculates a rounded number based on the number of digits you specify. […]

How to use the RANDARRAY function

The RANDARRAY function returns a table of random numbers across rows and columns. It is located in the Math and […]

How to use the SEQUENCE function

The SEQUENCE function creates a list of sequential numbers to a cell range or array. It is located in the […]

How to use the ROUNDDOWN function

What is the ROUNDDOWN function? The ROUNDDOWN function calculates a number rounded down based on the number of digits to […]

How to use the ROUNDUP function

What is the ROUNDUP function? The ROUNDUP function calculates a number rounded up based on the number of digits to […]

How to use the LOG10 function

What is the LOG10 function? The LOG10 function calculates the logarithm of a number using the base 10. What is […]

How to use the COTH function

What is the COTH function? The COTH function calculates the hyperbolic cotangent of a hyperbolic angle. The function has been […]

How to use the FLOOR.PRECISE function

The FLOOR.PRECISE function rounds a number down to the nearest integer or nearest multiple of significance. What is nearest multiple […]

How to use the CSC function

What is the CSC function? The CSC function calculates the cosecant of an angle (radians). The CSC function returns the same […]

How to use the GCD function

What is the GCD function? The GCD calculates the greatest common divisor that divides all given arguments without a remainder. What […]

How to use the MUNIT function

What is the MUNIT function? The MUNIT function calculates the identity matrix for a given dimension. What is an identity matrix? An […]

How to use the RAND function

What is the RAND function? The RAND function calculates a random real number greater than or equal to 0 and […]

How to use the MULTINOMIAL function

What is the MULTINOMINAL function? The MULTINOMIAL function calculates the ratio of the factorial of a sum of values to […]

How to use the MINVERSE function

What is the MINVERSE function? The MINVERSE function calculates the inverse matrix for a given array. What is a matrix? A […]

How to use the BASE function

What is the BASE function? The BASE function converts a decimal number into a text representation with a given radix […]

How to use the ATANH function

What is the ATANH function? The ATANH function calculates the inverse hyperbolic tangent of a number. What is hyperbolic? Hyperbolic functions […]

How to use the ATAN2 function

What is the ATAN2 function? The ATAN2 function calculates the arctangent of an angle using specific x- and y-coordinates. The […]

How to use the ATAN function

What is the ATAN function? The ATAN function calculates the arctangent of a number. The returned angle is in radians between […]

How to use the ASINH function

What is the ASINH function? The ASINH function calculates the inverse hyperbolic sine of a number. What is the SINE […]

How to use the ASIN function

What is the ASIN function? The ASIN function calculates the arcsine of a number. The angle is in radians and […]

How to use the ACOTH function

What is the ACOTH function? The ACOTH function calculates the inverse hyperbolic cotangent of a number. What is the trigonometric […]

How to use the ACOT function

What is the ACOT function? The ACOT function calculates the arccotangent of a given number which is an angle given […]

How to use the ACOSH function

What is the ACOSH function? The ACOSH function calculates the inverse hyperbolic cosine of a number. What is the cosine […]

How to use the ACOS function

What is the ACOS function? The ACOS function calculates the arccosine of a given number. What is arccosine? The arccosine […]

How to use the TRUNC function

What is the TRUNC function? The TRUNC function removes the fractional part of the number to an integer. Trunc stands […]

How to use the SERIESSUM function

What is the SERIESSUM function? The SERIESSUM function calculates the sum of a power series based on the following formula: […]

How to use the SECH function

What is the SECH function? The SECH function calculates the hyperbolic secant of an angle. What is a secant? The […]

How to use the COT function

What is the COT function? The COT function calculates the cotangent of an angle specified in radians. What is the […]

How to use the COSH function

What is the COSH function? The COSH function calculates the hyperbolic cosine of a number. What is the hyperbolic cosine […]

How to use the SINH function

What is the SINH function? The SINH function calculates the hyperbolic sine of a number. What is the hyperbolic sine […]

How to use the TANH function

What is the TANH function? The TANH function calculates the hyperbolic tangent of a number. What is the hyperbolic tangent? The […]

How to use the SUMXMY2 function

What is the SUMXMY2 function? The SUMXMY2 function calculates the sum of squares of differences of corresponding values in two […]

How to use the SUMX2PY2 function

What is the SUMX2PY2 function? The SUMX2PY2 function calculates the sum of squares of corresponding values in two arrays. The […]

How to use the SUMX2MY2 function

What is the SUMX2MY2 function? The SUMX2MY2 function calculates the sum of the difference of squares of corresponding values in […]

How to use the SUMSQ function

What is the SUMSQ function? The SUMSQ function calculates the sum of the squares of the arguments. What is the […]

How to use the SEC function

What is the SEC function? The SEC function calculates the secant of an angle. What is a secant? The trigonometric […]

How to use the FLOOR.MATH function

What is the FLOOR.MATH function? The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest […]

How to use the FIXED function

What is the FIXED function? The FIXED function rounds a number to the specified number of decimals, formats the number […]

How to use the FACTDOUBLE function

What is the FACTDOUBLE function? The FACTDOUBLE returns the double factorial of a number. How is the FACTDOUBLE function calculated? […]

How to use the DECIMAL function

What is the DECIMAL function? The DECIMAL function converts a text representation of a number in a given base into […]

How to use the CEILING function

What is the CEILING function? The CEILING function rounds a number up to its nearest multiple. The number is rounded […]

How to use the LCM function

What is the LCM function? The LCM function calculates the least common multiple. What is the least common multiplier? The […]

How to use the MROUND function

The MROUND function calculates a number rounded to a given multiple. What's on this page MROUND Function Syntax MROUND Function […]

How to use the SQRT function

What is the SQRT function? The SQRT function calculates the positive square root. What is a square root? The square […]

How to use the SIGN function

What is the SIGN function? The SIGN function returns the sign of a number. 1 for a positive number, 0 […]

How to use the LOG function

What is the LOG function? The LOG function calculates the logarithm of a number to a specific base. The log […]

How to use the LN function

What is the LN function? The LN function calculates the natural logarithm of a number. What is ln? Ln is […]

How to use the COMBINA function

What is the COMBINA function? The COMBINA function calculates the number of combinations with repetition for a given number of […]

How to use the PRODUCT function

What is the PRODUCT function? The PRODUCT function returns the product of the numbers given in the argument. What is […]

How to use the DEGREES function

What is the DEGREES function? The DEGREES function calculates degrees based on radians. What is degree? Degrees are a unit […]

How to use the RADIANS function

How to use the PI function

What is the PI function? The PI function returns the number pi (¶). What is the number pi? Pi is […]

How to use the POWER function

What is the POWER function? The POWER function calculates a number raised to a power. You can also use the […]

How to use the TAN function

What is the TAN function? The TAN function calculates the tangent of an angle in radians. What is the trigonometric […]

How to use the COS function

The COS function calculates the cosine of an angle. Table of Contents COS Function Syntax COS Function Arguments COS Function […]

How to use the SIN function

The SIN function calculates the sine of an angle. What's on this page SIN Function Syntax SIN Function Arguments SIN […]

How to use the EVEN function

What is the EVEN function? The EVEN function rounds a number up to the nearest even whole number. What is […]

How to use the EXP function

What is the EXP function? The EXP function returns e raised to the power of a given number What is […]

How to use the RANDBETWEEN function

What is the RANDBETWEEN function? Returns a random whole number between the numbers you specify. This function is volatile meaning […]

How to use the FACT function

What is the FACT function? The FACT function returns the factorial of a number. What is the factorial of a […]

How to use the INT function

The INT function removes the decimal part from positive numbers and returns the whole number (integer) except negative values are […]

How to use the COMBIN function

The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]

How to use the AGGREGATE function

The AGGREGATE function allows you to calculate different specific functions to a list or database. A special AGGREGATE function feature […]

How to use the ABS function

What is the ABS function? The ABS function converts negative numbers to positive numbers, in other words, the ABS function […]

How to use the SUMIFS function

The SUMIFS function calculates a total based on multiple criteria, it has been available in Excel since version 2010. I […]

How to use the SUBTOTAL function

What is the SUBTOTAL function? The SUBTOTAL function calculates a subtotal based on a cell range. The picture above shows […]

How to use the SUMIF function

The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or […]

How to use the SUM function

What is the SUM function? The SUM function in Excel allows you to add values, the function returns the sum […]

How to use the QUOTIENT function

The quotient function returns the integer portion of a division. Example, 5/2 = 2.5. The integer is 2. What's on […]

How to use the MOD function

The Mod function returns the remainder after a number is divided by a divisor. The Mod function is short for […]

How to use the SUMPRODUCT function

The SUMPRODUCT function calculates the product of corresponding values and then returns the sum of each multiplication.

How to use the MMULT function

The MMULT function calculates the matrix product of two arrays, an array as the same number of rows as array1 and […]