» Calculating the Lowest Common Multiple (LCM)
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Calculating the lowest common multiple of each pair of numbers in columns A & B.
Solution 1:
Use the MAX, LEFT, TEXT, and MIN functions in the following formula:
=MAX(A2:B2)*LEFT(TEXT(MIN(A2:B2)/MAX(A2:B2),"0000000/0000000"),7)
Solution 2:
Use the LCM function in the following formula:
=LCM(A2:B2)
Book Store:
Recommended Books:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Financial Peace: Revisited
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Microsoft Outlook 2002 for Dummies
- Fish! A Remarkable Way to Boost Morale and Improve Results
No comments have been submitted.
