Gcd

The function wizard for the Gcd function looks as follows:

Syntax

Gcd(Values1, …)

Parameters

Values1, Values2, …, ValuesN. The range of cells for which you want to find the greatest common divisor.

NOTE. All non-integers from the range are cut off to integers.

Description

It returns the greatest common divisor for two or more integers.

Example

Formula Result Description
=Gcd(B6:E6) 7 The greatest common denominator for the numbers from the cell range between B6 and E6. This range contains the following numbers: 21, 7, 14, 28.

See also:

Function Wizard | Mathematical Functions | Lcm | Trunc | IMath.Gcd