LCM Function in Excel: Least Common Multiple

⏱ 1 min readUpdated 28 September 2026

MathLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.

Syntax

=LCM(number1, [number2], ...)
Argument What it means
number1… Whole numbers.

Examples

Example 1

=LCM(6, 8)

Jobs every 6 and every 8 days coincide every 24 days.

GCD

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong