Find least common multiple in Excel
I am an astronomer. I know that the Earth takes 365 days to orbit the sun, while it takes 225 days for Venus. If today Earth and Venus are in perfect alignment with the sun, I want to find when this will happen again?
To do it in Excel, here is the answer:
a) Enter the formula =LCM(365,225) as shown below to get the number of days for the next alignment of Earth and Venus.
LCM stands for "Least Common Multiple" and returns the multiple common to 365 (days for the Earth to oribit the Sun) and 225 (days for the Venus to oribit the Sun).