Math and trigonometry functions
This article demonstrates the LET function introduced in Excel 365. What's on this page How to use the LET 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 […]
What is the LOG10 function? The LOG10 function calculates the logarithm of a number using the base 10. Table of […]
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 […]
What is the CSC function? The CSC function calculates the cosecant of an angle (radians). The CSC function returns the same […]
What is the GCD function? The GCD calculates the greatest common divisor that divides all given arguments without a remainder. What […]
What is the MUNIT function? The MUNIT function calculates the identity matrix for a given dimension. What is an identity matrix? An […]
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 the MINVERSE function […]
What is the BASE function? The BASE function converts a decimal number into a text representation with a given radix […]
What is the ATANH function? The ATANH function calculates the inverse hyperbolic tangent of a number. What is hyperbolic? Hyperbolic functions […]
What is the ATAN2 function? The ATAN2 function calculates the arctangent of an angle using specific x- and y-coordinates. The […]
What is the ATAN function? The ATAN function calculates the arctangent of a number. The returned angle is in radians between […]
What is the ASINH function? The ASINH function calculates the inverse hyperbolic sine of a number. What is the SINE […]
What is the ASIN function? The ASIN function calculates the arcsine of a number. The angle is in radians and […]
What is the ACOTH function? The ACOTH function calculates the inverse hyperbolic cotangent of a number. What is the trigonometric […]
What is the ACOT function? The ACOT function calculates the arccotangent of a given number which is an angle given […]
What is the ACOSH function? The ACOSH function calculates the inverse hyperbolic cosine of a number. What is the cosine […]
What is the ACOS function? The ACOS function calculates the arccosine of a given number. What is arccosine? The arccosine […]
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: […]
What is the SECH function? The SECH function calculates the hyperbolic secant of an angle. What is a secant? The […]
What is the COT function? The COT function calculates the cotangent of an angle specified in radians. What is the […]
What is the COSH function? The COSH function calculates the hyperbolic cosine of a number. What is the hyperbolic cosine […]
What is the SINH function? The SINH function calculates the hyperbolic sine of a number. What is the hyperbolic sine […]
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 […]
What is the SUMSQ function? The SUMSQ function calculates the sum of the squares of the arguments. What is the […]
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 […]
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. Table of Contents Introduction FACTDOUBLE Function […]
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 […]
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
What is the MROUND function? The MROUND function calculates a number rounded to a given multiple. What's on this page […]
What is the SQRT function? The SQRT function calculates the positive square root. The SQRT function is not the only […]
What is the SIGN function? The SIGN function returns the sign of a number. 1 for a positive number, 0 […]
What is the LOG function? The LOG function calculates the logarithm of a number to a specific base. The log […]
What is the LN function? The LN function calculates the natural logarithm of a number. Table of Contents Introduction LN […]
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
What is the RADIANS function? The RADIANS function converts degrees to radians. What is radian? Radians measure angles by the […]
What is the PI function? The PI function returns the number pi (¶). Table of Contents What is the number […]
What is the POWER function? The POWER function calculates a number raised to a power. You can also use the […]
What is the TAN function? The TAN function calculates the tangent of an angle in radians. What is the trigonometric […]
The COS function calculates the cosine of an angle. Table of Contents COS Function Syntax COS Function Arguments COS Function […]
The SIN function calculates the sine of an angle. What's on this page SIN Function Syntax SIN Function Arguments SIN […]
What is the EVEN function? The EVEN function rounds a number up to the nearest even whole number. What is […]
What is the EXP function? The EXP function returns e raised to the power of a given number. Table of […]
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 […]
What is the FACT function? The FACT function returns the factorial of a number. What is the factorial of a […]
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 […]
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
What is the SUMIFS function? The SUMIFS function calculates a total based on multiple criteria, it has been available in […]
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 […]
The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or […]
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 […]
What is the MOD function? The Mod function returns the remainder after a number is divided by a divisor. The […]
How to use the SUMPRODUCT function
The SUMPRODUCT function calculates the product of corresponding values and then returns the sum of each multiplication.
The MMULT function calculates the matrix product of two arrays, an array as the same number of rows as array1 and […]