Formula Functions > Functions D to G > GCD |
This function returns the greatest common divisor of two numbers.
GCD(number1,number2)
The arguments are two numeric values or arrays. If the arguments are not integers, they are truncated to integers. This function can have up to 255 arguments.
The greatest common divisor is the largest integer that divides both numbers without a remainder.
Accepts numeric data for all arguments. Returns numeric data.
GCD(B5,G7)
GCD(R5C2,R7C7)
GCD(3348,972) gives the result 108 GCD(12.8,16.3) gives the result 4
This function is available in product version 1.0 or later.
LCM | Math and Trigonometry Functions