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.