June 18, 2021

# How to use the Excel GCD function

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.

READ:  How to use the Excel DVARP function

#### Excel

View all posts by Excel →