=LCM(number1, [number2], ...)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single LCM formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number1:
The first number or cell reference for which you want to find the least common multiple (LCM).
number2:
An optional second number or cell reference for which you want to find the LCM. You can include additional numbers as needed.
...:
Additional numbers or cell references (up to 255) for which you want to find the LCM.
The LCM function in Excel is a mathematical tool that allows you to calculate the least common multiple of two or more integers. The least common multiple is the smallest positive integer that is divisible by each of the numbers in a given set. This function is particularly useful in various mathematical applications, including solving problems related to fractions, ratios, and scheduling.
In simpler terms, the LCM function helps you find a common multiple that can be used to simplify calculations involving multiple numbers.
Imagine you are organizing a schedule for two different events that occur at different intervals, and you want to find out when both events will occur simultaneously.
| Event | Frequency (Days) |
|---|---|
| Event A | 4 |
| Event B | 6 |
You want to determine the least common multiple of the frequencies of Event A and Event B to find out when both events will occur on the same day.
To calculate the least common multiple of the two events, you would use the LCM formula as follows:
=LCM(A2, A3)When you apply the formula, it calculates the least common multiple of 4 and 6. The output would be:
| Next Occurrence (Days) |
|---|
| 12 |
Here, the least common multiple is calculated as 12, meaning both Event A and Event B will occur together every 12 days.
The LCM function is particularly useful when you need to find common intervals or synchronize schedules involving multiple cycles. It allows you to efficiently determine when events will coincide, making it easier to plan and organize activities.
Understanding how to use the LCM function can significantly enhance your mathematical problem-solving capabilities in Excel, enabling you to manage schedules and calculations more effectively.
Happy calculating!
You have a project schedule where Column A contains the durations of various tasks in days, and Column B contains the frequencies at which these tasks need to be repeated. You can use the LCM function to calculate the least common multiple of the task durations, which helps in determining the optimal time frame for scheduling overlapping tasks. This ensures that all tasks align properly for efficient project management and resource allocation without the need for complex scheduling software.
Beyond the LCM function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.