Google Sheets-functie

LCM

Returns the least common multiple of integers.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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

The LCM function calculates the smallest positive integer that is a multiple of all argument numbers. It is commonly used for adding fractions with different denominators or scheduling recurring events.

Argumenten

number1vereistThe first number or range of numbers for which you want the least common multiple.
number2optioneelAdditional numbers for which you want the least common multiple.

Voorbeelden

=LCM(5, 2)

Resultaat: 10

The smallest number divisible by both 5 and 2 is 10.

=LCM(4, 6, 8)

Resultaat: 24

The smallest number divisible by 4, 6, and 8 is 24.

Veelgestelde vragen

What happens if an argument is not an integer?

The LCM function truncates non-integer values to integers.

Gerelateerde functies

GCD MOD