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:

Excel GCD function - How to use the Excel GCD function

Syntax:  =GCD(I116,J116)

Result:

Excel GCD function 1 - How to use the Excel GCD function

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.

Add a Comment

Your email address will not be published. Required fields are marked *