lcm - Least Common Multiple LCM The least common multiple...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Using 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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

lcm - Least Common Multiple LCM The least common multiple...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online