GCD() function

The Excel GCD function returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that goes into all supplied numbers without a remainder.

Syntax

The Syntax for the GCD Formula is:

=GCD(number1,number2,…)

Function Arguments

number1 – Two or more numbers, separated by commas, or an array of numbers.

GCD Function Examples

The following spreadsheet shows four examples of the Excel Gcd Function.

Formulas:

	A
1	=GCD( 1, 5 )
2	=GCD( 15, 10, 25 )
3	=GCD( 0, 8, 12 )
4	=GCD( 7, 2 )

Results:

	A
1	1
2	5
3	4
4	1

Notes:

Ø  The GCD function can accept up to 255 numbers as arguments.

Ø  If any argument is nonnumeric, GCD returns the #VALUE! error value.

Ø  If any argument is less than zero, GCD returns the #NUM! error value.

Ø  One divides any value evenly.

Ø  A prime number has only itself and one as even divisors.

Ø  If a parameter to GCD is >=2^53, GCD returns the #NUM! error value.

References

http://www.excelfunctions.net/Excel-Gcd-Function.html

https://exceljet.net/excel-functions/excel-gcd-function

https://support.office.com/en-us/article/GCD-function-d5107a51-69e3-461f-8e4c-ddfc21b5073a

http://www.automateexcel.com/functions/gcd-formula-excel

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501