GCD function - Zoho Sheet - Help Guide

GCD

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

 

Syntax

 

GCD(integer; [integer1; ...])
integer: Integers or ranges whose greatest common divisor you want to calculate. Eg., 23

 

Remarks

  • 1 divides all the integers evenly, and is returned when there is no common divisor for the given integers.


Examples  

   

Formula

Result

=GCD(23; 4; 32)

1

=GCD(12; 6)

6

=GCD(45,60,5,35)

5


Get a hands-on experience of the function in the embedded range below. 



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

#NUM!

  • One or more of the given arguments in less than zero.

 

Similar Functions


  1. LCM