Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > LCM
 

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

 
 Returns the least common multiple of integers.

 number1The first number
 number2The second optional number.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on.
     
  		• This function can be used to add fractions with different denominators.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If any of the argument are less than one, then #NUM! is returned.
     
  		• If any of the numbers are not an integer, then they are truncated.
     
  		• You can have a maximum of 29 arguments.

     EXAMPLES
     
     A
    1=LCM(5,2) = 10
    2=LCM(24,36) = 72
    3=LCM(24.9,36.9) = 72
    4=LCM(4,6) = 12
    5=(1/4)+(2/6) = 0.583
    6=((1*LCM(4,6)/4)/(4*LCM(4,6)/4))+(2*LCM(4,6)/(6*LCM(4,6))) = 0.583
    7=LCM("some text",36) = #VALUE!
    8=LCM(24,"some text") = #VALUE!
    		 
     Functions - L | Index - L | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top