GCD Formula
|
|
Numbers
|
|
Greatest
Divisor |
|
|
|
|
|
6
|
15
|
3
|
=GCD(C4,D4)
|
|
|
|
|
28
|
49
|
7
|
=GCD(C5,D5)
|
|
|
|
|
5
|
99
|
1
|
=GCD(C6,D6)
|
|
|
|
|
|
|
|
|
|
|
|
|
Numbers
|
|
|
Greatest
Divisor |
|
|
|
|
18
|
72
|
96
|
6
|
=GCD(C9,D9,E9)
|
|
|
|
300
|
500
|
200
|
100
|
=GCD(C10,D10,E10)
|
|
|
|
2.5
|
4
|
6
|
2
|
=GCD(C11,D11,E11)
|
|
|
|
|
|
|
|
|
|
|
What Does It Do ?
|
|
|
|
|
|
|
|
This function
calculates the largest number which can be used to divided all the
|
||||||
|
values
specified.
|
|
|
|
|
|
|
|
The
result is always a whole number.
|
|
|
|
|||
|
Where
there is no common divisor the value of 1 is used.
|
|
|
||||
|
Decimal fractions
are ignored.
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=GCD(Number1,Number2,Number3...
through to Number29)
|
|
|
||||
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
|
No
special formatting is needed.
|
|
|
|
|
||