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:

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)