# Documentation/Calc Functions/GCD

Other languages:
dansk • ‎English

GCD

Mathematical

## Summary:

The function gives the greatest common divisor of two or more positive integers.

The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given positive integers.

## Syntax:

GCD(Integer 1 [; Integer 2 [; … [; Integer 255]]])

## Returns:

Returns an integer which is the greatest common divisor of two or more positive integers passed as input.

## Arguments:

Integer 1, Integer 2, … , Integer 255 are integers, references to cells or to cell ranges of integers whose greatest common divisor is to be calculated.

• If any argument is negative, the function returns an error value.
• If any argument is non-integer, the function returns an integer GCD value. For e.g. GCD(2.5;5) will return 1 while GCD(8;2.2) will return 2.

If given two positive integers, a*b=LCM(a;b)*GCD(a;b).

## Examples:

Formula Description Returns
=GCD(16;32;24) the largest number that can divide 16, 24 and 32 without a remainder 8
=GCD(B1:B3) ,where cells B1, B2, B3 contain 9, 12, 9 the largest number that can divide 9, 12 and 9 without a remainder 3
=GCD(-16;32;24) function returns an error value since one of the arguments is negative Err:502

GCD_EXCEL2003

LCM

## ODF standard:

Section 6.13.36, part2

GCD