Lowest Common Multiple (LCM)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write a formula to get the lowest common multiple of 2 numbers. Looking in help I should be able to use the formula

=LCM(24,36)

and get 7

Excel is not reconizing LCM & I can't figure out what it is I need to do in the Data Analysis tools to fix the problem. HELP!
 
Do you have the Analysis Toolpak addin loaded - Tools / Addins / Tick Analysis
Toolpak - It is part of that and it must be installed for it to work.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Dianne said:
I'm trying to write a formula to get the lowest common multiple of 2 numbers.
Click to expand...
Looking in help I should be able to use the formula:
=LCM(24,36)

and get 72

Excel is not reconizing LCM & I can't figure out what it is I need to do in
Click to expand...
the Data Analysis tools to fix the problem. HELP!
 
Do you have the Analysis Toolpak addin loaded - Tools / Addins / Tick Analysis
Toolpak - It is part of that and it must be installed for it to work.
Click to expand...
...

It's possible without the ATP, as long as you cheat.

=MAX(A1:A2)*LEFT(TEXT(MIN(A1:A2)/MAX(A1:A2),
"000000000000000/000000000000000"),15)
 
Back
Top