Documentation/Calc Functions/GCD

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
dansk • ‎English

Function name:

GCD

Category:

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.

Additional details:

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

Related LibreOffice functions:

GCD_EXCEL2003

LCM

ODF standard:

Section 6.13.36, part2

Equivalent Excel functions:

GCD