Forum Discussion
ESAM_HASHIM
Apr 13, 2022Brass Contributor
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 were
- 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
- 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
Sort By
- ESAM_HASHIMBrass ContributorAfter 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