The LCM() and GCD() Functions in Excel: A Tutorial
In this tutorial, you will learn how to use the LCM() and GCD() functions in Excel to find the least common multiple and greatest common factor of two or more numbers.
The LCM() function returns the smallest number that is a multiple of all the numbers in a range. The GCD() function returns the largest number that is a factor of all the numbers in a range.
These functions can be used to solve a variety of problems in Excel, such as finding the smallest number of items that need to be purchased to have enough for each person in a group, or finding the largest number of groups that can be formed from a set of items.