Microsoft Excel Functions & Formulas

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.

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.

4

To determine the greatest common divisor:

1. In cells A2:A10 list any valid numbers.

2. In cells B2:B10 list any valid numbers.

3. Select cells C2:C10.

4. Type the following formula: =GCD(A2,B2).

5. Press <Ctrl+Enter>.

184

Chapter 6

Figure 6-39 ...