Least Common Multiple
– LCM
The least common multiple can be calculated using Excel's LCM function. See the table
below for a detailed list of the exercises and problems in the text that can be solved using
this function.
This function is included in the Analysis ToolPak.
Syntax
=LCM(number1,number2,…)
General Example
The following general example shows how the LCM function can be used. Notice that
the LCM function appears in the formula bar.
1
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentUsing the LCM Function in a Spreadsheet
To calculate the least common multiple of a group of values, create a spreadsheet by
following Steps 1 to 6. Or, to use the LCM function right away, open the LCM
worksheet in the Excel Functions Templates workbook.
Step 1
: Enter the title
LCM Function
in cell
A1
. You will replace
LCM Function
with
your project title when you use the spreadsheet for a particular question or
situation.
Step 2
: In cell
B2
enter
Original
Denominator
.
In cell
A3
enter
First
Integer
.
In cell
A4
enter
Second
Integer
.
In cell
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '05
 TonyCirusolo
 Math, insurance companies, insurance policy, Greatest common divisor, Least common multiple, lcm function, $224 640

Click to edit the document details