The GCD Function Calculates the greatest common divisor between two or more numbers. The greatest common divisor is the largest integer that will divide into all of the numbers. For example, =GCD(91,46) returns 1.
Syntax: = GCD (number1, [number2], …)
The GCD function syntax has the following arguments:
- number1: The first number.
- number2 (Optional): The second number.
Example: Let’s look at some Excel GCD function examples and explore how to use the GCD function as a worksheet function in Microsoft Excel:
Syntax: =GCD(I116,J116)
Result:
Based on the Excel spreadsheet above, the following GCD examples would return:
Syntax: =GCD(I117,J117)
Result: 2
Syntax: =GCD(I118,J118)
Result: 2
Syntax: =GCD(I119,J119)
Result: 8
Syntax: =GCD(I120,J120)
Result: 1
Syntax: =GCD(I121,J121,K121)
Result: 2
Syntax: =GCD(I122,J122,K122)
Result: 375
Note: Use the GCD function to get the greatest common divisor of two or more integers. The greatest common divisor is the largest positive integer that divides the numbers without a remainder.
