Functions
LCM
Least common multiple
Try it
When to use it
When is LCM useful in a spreadsheet?
Use LCM to find the smallest interval that satisfies multiple repeating cycles, such as synchronized maintenance schedules or the least common billing period across subscriptions.
Used in
Syntax
LCM(value1,...)Examples
=LCM(4,6) // => 12
=LCM(2,3,5) // => 30
=LCM(12,18) // => 36