Basic math functions: gcd, lcm, mround, multinomial, sqrt, sqrtpi

Excel Function GCD

The GCD() function is used to determine the greatest common divisor of a group of numbers.

This function can take more than two arguments but are limited to a maximum of 255.

The Syntax is : GCD(num1,num2�num255)

GCD() Remarks Formula
1 NA =GCD(2,5,4,3)
2 NA =GCD(2,4,6,8,10)
#NUM! Contains negative number =GCD(-2,4,7,90)
2 NA =GCD(0.1,2,0.8)
2 NA =GCD(200,102)

 

 

Excel Function LCM

The LCM() function is used to determine the lowest common multiple of a given set of numbers.

This function too is limited to a maximum of 255 arguments.

The Syntax is LCM(num1,num2,..num255)

LCM() Remarks Formula
60 NA =LCM(2,5,4,3)
120 NA =LCM(2,4,6,8,10)
#NUM! Contains negative number =LCM(-2,4,7,90)
0 NA =LCM(0.1,2,0.8)
10200 NA =LCM(200,102)

 

 

Excel Function MROUND

The MROUND() function rounds the specified number to the nearest multiple of the given number.

This function rounds the number either up or down whichever is nearer.

This function takes two arguments.

The Syntax is : MROUND(number, multiple)

Number Multiple MROUND() Formula
2 5 0 =MROUND(L29,M29)
3 2 4 =MROUND(L30,M30)
5 8 8 =MROUND(L31,M31)
7 -5 #NUM! =MROUND(L32,M32)
-9 13 #NUM! =MROUND(L33,M33)

As seen from the above, a negative number on either of the arguments results in an error.

 

 

Excel Function MULTINOMIAL

The MULTINOMIAL() function calculates the multinomial of the supplied numbers.

A multinomial is nothing but the ratio of factorial of sum of the values to the factorial of its products.

The formula is as given:

excel basic math functions gcd lcm mround multinomial sqrt sqrtpi

This function can take a maximum of 255 arguments.

MULTINOMIAL() Remarks Formula
105 NA =MULTINOMIAL(1,2,4)
#NUM! Negative number =MULTINOMIAL(1,-2,4)
5 NA =MULTINOMIAL(1,0.2,4)

 

 

Excel Function SQRT

The SQRT() function is used to calculate the square root of a given number.

The important thing is that, this function calculates the square root of positive numbers only.

The syntax is SQRT(number)

SQRT() Remarks Formula
10 No error =SQRT(100)
#NUM! Negative number =SQRT(-4)
#NAME? Non numeric values =SQRT(a)

 

 

Excel Function SQRTPI

The SQRTPI()Function returns the square root of the product of a given number and the constant pi.

The mathematical constant pi=3.14.

There is no need to explicitly multiply the value by pi as it will be done automatically.

The Syntax is SQRTPI(number).

SQRTPI() Remarks Formula
17.7245385090552 No error =SQRTPI(100)
#NUM! Negative number =SQRTPI(-4)
#NAME? Non numeric values =SQRTPI(a)

 

You can find similar Excel Questions and Answer hereunder

1) basic math functions hyperbolic functions sinh cosh tanh csch sech coth

2) basic math functions degrees radians rand

3) basic math functions mdeterm minverse mmult

4) basic math functions asin acos atan acot

5) basic math functions sin cos tan csc sec cot

6) basic math functions seriessum sumsq sumx2my2 sumx2py2 sumxmy2 subtotal

7) basic math functions ceiling combin exp fact floor

8) basic math functions power product quotient mod sum

9) How can I calculate depreciation of assets using Excel?

10) basic math functions round rounddown roundup sign

 

Here the previous and next chapter