» Calculating the Lowest Common Multiple (LCM)
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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 Interpretation of Financial Statements
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Windows XP Pocket Reference
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Marketing Planning for Services
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
