Live Chat Software by Kayako |
Knowledgebase: Internet-Desktop Support
: 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) | |
|
Comments (0)