{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# gcd - Greatest Common Divisor GCD The greatest common...

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

Greatest Common Divisor – GCD The greatest common divisor can be calculated using Excel's GCD 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 =GCD(number1,number2,…) If a cell reference is nonnumeric, GCD returns the #VALUE! error value. If the value in a cell reference is less than zero, GCD returns the #NUM! error value. General Example The following general example shows how the GCD function can be used. Notice that the GCD function appears in the formula bar. 1

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

View Full Document
Using the GCD Function in a Spreadsheet To calculate the greatest common divisor of a group of values, create a spreadsheet by following Steps 1 to 9. Or, to use the GCD function right away, click on the GCD worksheet in the Excel Functions Templates workbook. Step 1 : Enter the title GCD Function in cell A1 . You will replace GCD Function with your project title when you use the spreadsheet for a particular question or situation. Step 2 : In cell C2 enter Final Result . In cell A3 enter First Integer . In cell A4 enter Second Integer . In cell A5 enter Third Integer .
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

gcd - Greatest Common Divisor GCD The greatest common...

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

View Full Document
Ask a homework question - tutors are online