How to use the GCD function to determine the greatest common divisor
In this example, the greatest common divisor of two integers has to be determined. To do so, use the GCD function. This function is only available if you have the Analysis ToolPak add-in installed. Here is the syntax that is used:
GCD(number1, number2, …)
number1, number2, …: From 1 to 29 values for which you want to find the greatest common divisor. Non-integer values are truncated.
To determine the greatest common divisor:
- In cells A2:A10 list any valid numbers.
- In cells B2:B10 list any valid numbers.
- Select cells C2:C10.
- Type the following formula: =GCD(A2,B2).
- Press Ctrl+Enter.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Use the LCM function to determine the least common multiple
- How to Use the SUMSQ function to determine the square sum
- Use the EVEN and ODD functions to determine the nearest even/odd value
- Use the QUOTIENT function to return the integer portion of a division
- How to Use the RANK function to determine the rank of sales
