LCM Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

LCM is an Excel Math & Trig function. Returns the least common multiple of a set of numbers.

LCM syntax

=LCM(number1, [number2], ...)

LCM is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try LCM yourself. No Excel install or sign-up needed to start.

What does the LCM function do in Excel?

Returns the least common multiple of a set of numbers.

What is the syntax of LCM in Excel?

The syntax is =LCM(number1, [number2], ...). number1: The first number or range; number2: An additional number or range (optional).

Where can I practice LCM online for free?

Open the free live spreadsheet on Cellgrids and try LCM yourself. No Excel install is needed and you can start without signing up.