Find the lowest common denominator or greatest common factor in Excel
All of us may remember that we are asked to calculate some numbers’ lowest common denominator or greatest common factor when we are students. But if there are ten or more and some big numbers, this work will be complicated. Fortunately, Excel provides some functions for us to get the lowest common denominator or greatest common factor of numbers. Please read this article for the details.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To get the lowest common denominator of the given numbers, please apply the LCM function.
Put your numbers in cells of your worksheet, and enter this formula: =LCM(A1:A4) in a blank cell, see screenshot:
And then press Enter key, you will calculate the lowest common denominator of the numbers in the cells range.
If you need to calculate the greatest common factor of several numbers, the GCD function can help you.
In a blank cell, please type this formula: =GCD(A1:A4), see screenshot:
Then tap Enter key, and the greatest common factor of the given numbers has been calculated.
Note: In the above formulas, A1: A4 indicates the range cells of the numbers that you want to calculate their greatest common factor