Please disable your adblock and script blockers to view this page

Math and trigonometry functions

How to use the LET function

This article demonstrates the LET function introduced in Excel 365. What is the LET function? The LET function in Excel […]

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

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

How to use the SEQUENCE function

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

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. Table of […]

How to use the FLOOR.PRECISE function

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

How to use the CSC function

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

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. Table […]

How to use the MUNIT function

What is the MUNIT function? The MUNIT function calculates the identity matrix for a given dimension. Table of Contents Introduction Syntax Example […]

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 MULTINOMIAL 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 […]

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 ATAN2 function

What is the ATAN2 function? The ATAN2 function calculates the arc-tangent 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 ASIN function

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

How to use the ACOT function

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

How to use the ACOS function

What is the ACOS function? The ACOS function calculates the arc-cosine of a given number. Table of Contents Introduction Syntax […]

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 COT function

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

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 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. Table of Contents […]

How to use the SEC function

What is the SEC function? The SEC function calculates the secant of an angle. Table of Contents Introduction Syntax Example […]

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 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. Table of Contents Introduction Syntax Example 1. […]

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 […]

How to use the SQRT function

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

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. Table of Contents Introduction Syntax […]

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. Table of […]

How to use the DEGREES function

What is the DEGREES function? The DEGREES function calculates degrees based on radians. Degrees are denoted by °. Table of […]

How to use the RADIANS function

What is the RADIANS function? The RADIANS function converts degrees to radians. Table of Contents Introduction Syntax Example 1 Example […]

How to use the PI function

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

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. Table of Contents Introduction […]

How to use the COS function

What is the COS function? The COS function calculates the cosine of an angle. Table of Contents Introduction Syntax Example […]

How to use the SIN function

The SIN function calculates the sine of an angle. What's on this page Introduction Syntax Example How to use degrees […]

How to use the EVEN function

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

How to use the EXP function

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? It returns a random whole number between the numbers you specify. This function is volatile […]

How to use the FACT function

What is the FACT function? The FACT function returns the factorial of a number. Table of Contents Introduction Syntax Example […]

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

What is the AGGREGATE function? The AGGREGATE function allows you to calculate different specific functions to a list or database. […]

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

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 […]

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. The remainder is left out. This function is useful in […]

How to use the MOD function

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.

How to use the MMULT function

What is the MMULT function? The MMULT function calculates the matrix product of two arrays, an array as the same number […]