Spread Formula Reference
Formula Functions / Functions H to L / LCM
In This Topic
    LCM
    In This Topic

    This function returns the least common multiple of two numbers.

    Syntax

    LCM(number1,number2)

    Arguments

    For the arguments, use numeric values or arrays. If the arguments are not integers, they are truncated to integers. This function can have up to 255 arguments.

    Remarks

    The least common multiple is the smallest positive integer that is a multiple of all integers given.

    Use this function to add fractions with different denominators by calculating the least common multiple of both denominators first.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    LCM(B12,C22)

    LCM(R12C2,R22C3)

    LCM(300,500) gives the result 1500

    LCM(12.3,16.99) gives the result 48

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    GCD | Math and Trigonometry Functions