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).

excel find least common multiple

 

You can find similar Excel Questions and Answer hereunder

1) How can I enter multiple lines of data in a cell?

2) How can I identify all cells with Conditional Formatting in my WorkSheet?

3) Given a raw data Table, how can I find the value of a field for a specific value of another field?

4) Split string into multiple columns in Excel

5) How can I find the count of records that meet multiple conditions in my raw data table?

6) Vlookup to return multiple values in same cell in Excel

7) How can I identify the cells that are dependent on a particular cell?

8) How can I sort data using multiple criteria?

9) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

10) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

 

Here the previous and next chapter