Returns the greatest common divisor of two or more integers.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
GCD(number1, [number2], ...)The GCD function calculates the largest positive integer that divides each of the provided numbers without a remainder. If any argument is non-numeric, the function returns the #VALUE! error value.
=GCD(12, 18)結果: 6
The largest number that divides both 12 and 18 is 6.
=GCD(24, 36, 48)結果: 12
The greatest common divisor for 24, 36, and 48 is 12.
The GCD function uses the absolute value of any negative number provided.