Evaluate the Least Common Multiple in fractions in Excel

Occasional 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




1 Reply
After a lot of search, I find the answer by LCM Formula (Least Common Multiple) as shown below in any blank cell: