Forum Discussion
Evaluate the Least Common Multiple in fractions in Excel
Hi to all I am the first time inter this website In the following spread sheet, the first row (Red numbers) includes the denominators of multiple fractions such as 1/12, 1/36, 1/60, 1/72 and else ...
After a lot of search, I find the answer by LCM Formula (Least Common Multiple) as shown below in any blank cell:
=LCM(A1:R1)
19,958,400
=LCM(A1:R1)
19,958,400