The greatest common divisor is the largest positive integer that divides the numbers without a remainder.

In other words, the largest number that goes into all numbers evenly.

The GCD function takes one or moreargumentscallednumber1,number2,number3, etc.

Excel formula: Calculate a ratio from two numbers

All numeric values are expected to be integers.

Numbers with decimal values will be truncated to integers before a result is calculated.

Each argument can be a hardcoded constant, a cell reference, or arangethat contains multiple values.

Excel LCM function

The GCD function can accept up to 255 arguments total.

The least common multiple is the smallest positive integer that is a multiple of all supplied numbers.

For example, =LCM(25,40) returns 200.