GCD Formula in Excel

 

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.

image

Syntax

=GCD(Number1,Number2,Number3... through to Number29)

Formatting

No special formatting is needed.

No comments:

Post a Comment