Quantunet.com

My Account

Joins Us
Excel QuickSkills
The LCM() Function Knowledgebase  

 

The LCM function finds the lowest common multiple of a set of numbers.

  • The syntax for the function is LCM (number 1, number 2, ...number n).

Where "number 1, number2,...number n" are numeric values or a reference to values of which the lowest common multiple is to be found.

The LCM function takes the arguments and finds the lowest common multiple that is the lowest number that both numbers can divide into. For example LCM(6,8) = 24 as 6 goes into 24 four times and 8 goes into 24 three times but there is no smaller number that both 6 and 8 can divide into a whole number of times.

This function can be useful when adding or subtracting fractions with different denominators and the lowest common denominator needs to be found.



How to use the LCM() function:

  • Type " =LCM( "
  • Enter the coordinates of the range of data "A2:A5"
  • Type ")" then press the "Enter" key. 







 


Note: If non integer arguments are entered into the LCM function they are truncated.



© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us