Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
LCM
LCM finds the smallest positive integer that is evenly divisible by all supplied numbers. It is the complement of GCD and is useful for scheduling tasks that repeat on different cycles or finding common denominators.
Excel
=LCM(A2,B2)Google Sheets
=LCM(A2,B2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Cycle A | Cycle B | LCM |
| 4 | 6 | |
| 3 | 5 | |
| 8 | 12 | |
| 7 | 14 |
=LCM(A2,B2)→12
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 and B2 are the integers whose least common multiple you want.
- 2LCM(4,6) returns 12 because 12 is the smallest number divisible by both 4 and 6.
- 3Supply more values as additional arguments; all must be non-negative integers.
Need a version for your data?
Try: “Find the least common multiple of two cycle lengths to align schedules”