ExcelFlux

LCM function

the least common multiple.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Find when two maintenance intervals first coincide.

A worked example from the workbook

RowAB
6First valueSecond value
768
8410
9713
Record 1
=LCM(A7,B7)

Expected result24

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=LCM(6,8)
Turkish Excel · tr-TR
=OKEK(6;8)

Expected result

24

Worked examples

Find when two maintenance intervals first coincide.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 6 8
8 4 10
9 7 13
Case Formula Expected result
Record 1 =LCM(A7,B7) 24
Record 2 =LCM(A8,B8) 20
Record 3 =LCM(A9,B9) 91
Microsoft Excel reference