Evaluate the Least Common Multiple in fractions in Excel

Brass Contributor

Hi to all

I am the first time inter this website

  1. 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 were
  2. As shown in this sheet I get from multiple calculations the specified value in S16 cell (19,958,400) that can be divided on each number in first row without decimal value
  3. My question is are there a formula that can be applied to get the greatest value shown in S16 without multiple calculations

Kind Regards

NOTE:  The original spread sheet is in the following link

https://onedrive.live.com/edit.aspx?resid=AC822C5DC82A8A59!71228&ithint=file%2cxlsx&authkey=!AKM4qAj...

 

2022-04-12_11-47-54.jpg

1 Reply
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