GCD function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• COS
• SIN
• TAN
• COT
• ACOS
• ACOT
• ASIN
• ATAN
• ATAN2
• DEGREES
• RADIANS
• PI

Hyperbolic

• COSH
• SINH
• TANH
• COTH
• ACOSH
• ACOTH
• ASINH
• ATANH

Rounding and remainders

• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• INT
• QUOTIENT
• MOD

Logarithm/Powers

• EXP
• POWER
• LOG
• LN
• LOG10

Bessel functions

• BESSELI
• BESSELJ
• BESSELK
• BESSELY

Miscellaneous

• ABS
• COMBIN
• COMBINA
• CONVERT
• CONVERT ADD
• COUNTBLANK
• COUNTIF
• DELTA
• ERF
• ERFC
• FACT
• FACTDOUBLE
• GCD
• GCD ADD
• GESTEP
• ISEVEN
• ISODD
• LCM
• LCM ADD
• MULTINOMIAL
• PRODUCT
• RAND
• RANDBETWEEN
• SERIESSUM
• SIGN
• SQRT
• SQRTPI
• SUBTOTAL
• SUM
• SUMIF
• SUMSQ

< Previous Page

Next Page >

GCD

Returns the greatest common divisor of two or more integers.

Syntax:

GCD(integer1; integer2; ... integer30)

integer1 to integer30 are up to 30 integers or ranges of integers whose greatest common divisor is to be calculated.

The greatest common divisor (or highest common factor) is the largest positive integer which will divide, without remainder, each of the given integers.

Example:

GCD(16; 32; 24)

returns 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder.

GCD(B1:B3)

where cells B1, B2, and B3 contain 9, 12, and 6 returns 3.

GCD(3; 5)

returns 1.

---

See Also

• GCD_ADD
• LCM
• LCM_ADD

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category