Forum Discussion

ESAM_HASHIM's avatar
ESAM_HASHIM
Brass Contributor
Apr 13, 2022

Evaluate the Least Common Multiple in fractions in Excel

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=!AKM4qAjt5qbCgY0

 

1 Reply

  • ESAM_HASHIM's avatar
    ESAM_HASHIM
    Brass Contributor
    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

Resources