ProductSolutionsTemplatesResourcesPricing

LCM

Returns the least common multiple of one or more integers. Learn more

Video field
Math

LCM is a function in Google Sheets that returns the least common multiple of one or more integers. The function takes one or more arguments:

value1: the first integer whose multiples you want to find the least common multiple of. value2, … (optional): additional integers whose multiples you want to find the least common multiple of. The syntax for using the LCM function in Google Sheets is:

=LCM(value1, [value2, …])

For example, if you want to find the least common multiple of the integers 6 and 9, you can use the LCM function in Google Sheets as follows:

=LCM(6, 9)

The result would be 18, which is the smallest integer that is a multiple of both 6 and 9.

If you want to find the least common multiple of more than two integers, you can include additional arguments in the LCM function. For example, if you want to find the least common multiple of the integers 4, 6, and 8, you can use the LCM function in Google Sheets as follows:

=LCM(4, 6, 8)

The result would be 24, which is the smallest integer that is a multiple of all three integers.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!