< Go Back

Excel GCD Function

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.

Example 1

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.

  1.     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

  1.     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

  1.     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.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar