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.
 Fall '05
 TonyCirusolo
 Math, Greatest common divisor, #VALUE, #DIV, #NUM, Hummelbrunner

Click to edit the document details