GCD, INT, & LCM

[WayneLambert]

GCD

GCD stands for Greatest Common Divisor. It returns the greatest divisor that is common to all of the arguments passed to the function.

=GDC(20,25,100) would be 5 because 5 goes into 20, 25 and 100. There is no number between 5 and 20 that also does that.

INT

INT always rounds down to the nearest integer. Therefore =INT(-9.8) evaluates to -10. Rounding down is done irrespective of whether the number is positive or negative.

LCM

LCM stands for Lowest Common Multiple. It returns the smallest number that is a multiple of all of the arguments passed to the function.

=LCM(3,4)  # Is 12
=LCM(3,4,5) # Is 60
=LCM(3,4,5,6)  # Is also 60