GCD

Calculates the greatest common denominator of the values in a data set.

Syntax:

GCD(list)

Returns the greatest common denominator of all the values in the list.

list may be an array, a range of cells, or a comma-separated list of values.

Example:

GCD(B1:B3)

returns the greatest common denominator of the values of cells B1:B3.

Revisions:

This function was added in 2.24.