: Calculating the Lowest Common Multiple (LCM)
Posted by - NA - on 20 March 2006 08:36 AM
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)


(432 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion