GCD Function (Functions in Excel)
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. |
0 comments:
Post a Comment