Find the Lowest Common Multiple or Greatest Common Divisor in Excel

Microsoft Excel is known to help in easing mathematical calculations. We all know of tools for simple mathematical formulas like addition, subtraction, etc, however, as we move to more complex mathematical functions, we would need to use formulae to process the function on Excel.

Find the Lowest Common Multiple or Greatest Common Divisor in Excel

One such case is while trying to find the lowest common denominator or greatest common factor in Excel. If you wish to find the lowest common multiple or greatest common divisor in Excel, check the following procedures:

  1. Find the Lowest Common Multiple (LCM) of a range of numbers
  2. Find the Greatest Common Divisor (GCD) of a range of numbers.

1] Find the Lowest Common Multiple of a range of numbers in Excel

Lowest Common Multiple: The Lowest Common Multiple or LCM of a bunch of numbers is the smallest common multiple of those integers. This means all those numbers would be divisible by the LCM while giving an integer value. LCM is useful for calculating problems related to gears and planetary alignment.

If you wish to find the lowest common multiple of a bunch of numbers in Excel, place those numbers sequentially in the same column. In that case, the syntax for the lowest common denominator formula would be as follows:

=LCM(<first cell with number>:<last cell with number>)

Eg. Let us say we place the four numbers for which we need to calculate the lowest common denominator from cell A4 to cell A7. Then the formula to calculate the lowest common denominator would become as follows:

=LCM(A4:A7)

In the example mentioned (as observed in the screenshot), we place the formula in cell C4 and Enter to get the result.

Find the Lowest Common Multiple or Greatest Common Divisor in Excel

2] Find the greatest common divisor of a range of numbers in Excel

Greatest Common Divisor: The Greatest Common Divisor or GCD is the highest integer number that could be used to divide the bunch of numbers in question and give and an integer value.

Should you need to find the lowest common denominator of a bunch of numbers in Excel, place those numbers sequentially in the same column. In such a case, the syntax for the lowest common denominator formula would be as follows:

=GCD(<first cell with number>:<last cell with number>)

Eg. Let us say we place the four numbers for which we need to calculate the lowest common denominator from cell A4 to cell A7. Then the formula to calculate the lowest common denominator would become as follows:

=GCD(A4:A7)

We will place the formula in cell C4 and Enter to get the result and shown in the screenshot.

Greatest common divisor

Even if you miss cells in a column, the formula would work as far as the first cell and the last cell are correct. It is important for all the values to be in the same column.

Hope you can get it working.

Posted by on , in Category Office with Tags
Karan Khanna is a passionate Windows 10 user who loves troubleshooting Windows problems in specific and writing about Microsoft technologies in general.

Leave a Reply

Your email address will not be published. Required fields are marked *


1 + 2 =