Skip to main content

GCD

Definition of GCD

Returns the greatest common divisor of one or more integers.

Sample Usage

GCD(A2:A5)

GCD(24,96,A4)

Syntax

GCD(value1, [value2, ...])

  • value1 - The first value or range whose factors to consider in a calculation to find the greatest common divisor.

  • value2, ... - [ OPTIONAL ] - Additional values or ranges whose factors to consider to find the greatest common divisor.

Notes

  • Any input with a decimal part provided to GCD will be silently truncated.

See Also

LCM: Returns the least common multiple of one or more integers.

In order to use the GCD formula, start with your edited Excellentable

Then type in the GCD Formula in the area you would like to display the outcome:

Type in the complete GCD formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

Error.

User does not have sufficient privileges to access this Content
Learn More


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.