As it is clear by the name GCD, the function stands for Greatest Common Divisor of two or more than two integers. It means that the numbers can be divided by a single number without leaving any remainder.
What is GCD Function in Excel?
The GCD function in Excel is given to perform the GCD operation. It will return the value of the greatest common divisor of two or more positive integers. GCD is the largest integer that divides the all the given number without a remainder value.
How is the GCD function used in Excel?
It is very simple to use the GCD function in Excel. The function is entered by selecting the GCD function in the Formula tab. The integer numbers are added in the cells within a given range. The proper method of using the GCD function as the formula is briefly provided in the further section.
Formula or Syntax
=GCD([number 1],[number 2],…)
Parameters or Arguments of GCD function
The GCD function consists of the following arguments:
- Number 1, Number 2, … The Number 1 is mandatory, the other numbers are optional. Only the argument values from 1 to 255 are accepted by the function. If the value of the integer is not positive, then it is truncated.
Now, we will take an example to learn exactly how the formula works in Excel sheet. Follow the steps carefully and you’ll know how to apply the formula to the numbers.
- Let us take two numbers for the calculation, 12 and 24. Enter the first integer 12 in a cell and 24 in the other.
Figure 1. Enter the value of the integers in the cells
- Now, click on the cell next to the number and then select the button to apply the GCD function. The GCD function window will appear where the numbers will be entered. Then tap on the OK button.
Figure 2. Use to apply GCD function and enter the value
- The result of the GCD formula will be displayed in the selected cell and you will have the greatest common divisor value of the integers.
Figure 3. The GCD value calculated by the function is displayed on the screen
Note on Usage of GCD Function
- The function will return #VALUE! error value if the entered argument is non-numeric.
- The function will return #NUM! error value if one of the arguments is zero.
- All the values are divided by one evenly.
- The divisor of a Prime number is one and the number itself.
- The function will also return #NUM! error value if the parameter is in the form >=3^23.