Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Determining the Least Common Multiple.
Written by Allen Wyatt (last updated September 30, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
Remember your junior-high math classes? The teacher would write three or four numbers on the chalkboard and ask you to determine what larger number each of the numbers on the board could be a factor of. For instance, if the numbers were 2, 3,and 4, then they are all factors of the number 12. Thus, 12 is the least common multiple of those three numbers.
Things got really difficult when the teacher threw up six, seven, or ten numbers. Yikes! Fortunately, Excel makes calculating the least common multiple rather easy. All you need to do is put the numbers in a range of cells, and then use a formula like this:
=LCM(C20:C23)
In just a jiffy Excel returns a value that, sure enough, would have made that math teacher proud.
Just one gotcha here: If you use non-integer values with the LCM function, everything past the decimal point is ignored. In other words, the values are truncated before LCM does its magic. So, the bottom line is to make sure you are working with actual integers with LCM.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (5833) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Determining the Least Common Multiple.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
Excel allows you to easily develop formulas that pull values from worksheets and workbooks other than the one in which ...
Discover MoreIf you need to modify information in a text string, two common functions you can use are SUBSTITUTE and REPLACE. This tip ...
Discover MoreNeed to know the column number for use in a formula? The worksheet function you want is the COLUMN function, described in ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2023-09-30 10:26:18
J. Woolley
The Tip's example can also be entered like this:
=LCM(C20,C21,C22,C23)
or any related comination.
You might also be interested in the greatest common divisor:
=GCD(...)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here:
Comments