Math & Trig
All versions
◉ 12 views
=LCM()
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=LCM(number1, [number2], ...)
Hover argument names in the table for details.
Output typeNumber
Popularity8 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =LCM() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number1 |
Number | Required | , number2,... Number1 is required, subsequent numbers are optional. 1 to 255 values for which you want the least common multiple. If value is not an integer, it is truncated. |
▣ Examples
کوچکترین مضرب مشترک ۵ و ۲
=LCM(5, 2)
کوچکترین مضرب مشترک ۲۴ و ۳۶
=LCM(24, 36)
⚠ Common Errors
#VALUE!
If any argument is nonnumeric, LCM returns the #VALUE! error value.
Fix: فقط مقادیر عددی وارد کنید و بررسی کنید سلولهای مرجع حاوی متن نباشند.
#NUM!
If any argument is less than zero, LCM returns the #NUM! error value. If LCM(a,b) >=2^53, LCM returns the #NUM! error value.
Fix: Correct the input value
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!