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.