GCD Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is considered as one of the most functional program utilized in so many companies and businesses. Some companies even use it as a prerequisite or requirement when you are applying for a job. Most of the establishments that require such skills are those companies that are engage in engineering, financial and accounting computation.

However, if Excel is used for calculating, one must learn the different functions of the worksheet. This will help you a lot in doing the computation correctly and quickly. Those individuals that’s utilizing Excel in managing and sorting data, they have to be familiar with the different functions in order to administer and manage their data efficiently. By reading this article, you will be acquainted to one of the functions in Excel which is very useful when it comes to computation – the GCD function.

Description of GCD Function:

GCD function in Excel is utilized to get the greatest common divisor of different numbers. The greatest common divisor is the biggest common number that divides the given numbers without having or getting remainders. This function is best to use when simplifying fractions because this is required in the solution to find the highest divisor that can both divide the numerator and denominator.

Formula of GCD Function:

In using the function in Excel the syntax to observe is:

=GCD(number 1, number 2, number 3, and so on……..)

In the formula the value of numbers 1, 2, 3 and so on are equals to the diverse numbers desired to find for greatest common divisor.

GCD function example

Take a look at the example below and try it to Microsoft Excel program:

Example 1:

In this given numbers: 85, 62, 59, 74 the GCD is 1.

To find the answer using the GCD function of Microsoft here are the ways to do it:

  • For instance all the given data are written on the spreadsheet, just click an empty cell on the spreadsheet. The empty cell will be the location of the answer.
  • From the empty cell, type in the GCD function syntax which is =GCD(number 1, number 2, number 3, number 4). For the arguments to have value, just click the reference cell of every number.
  • Once all the value are entered in, press the enter tab and the answer to appear is one.

Example 2:

In the given: 1000, 200, 500, 800000 the GCD is 100

You can try to do GCD function on your own by just following the procedures written on Example number 1.

Common Errors

It is normal, that while doing the different functions of Microsoft Excel program there are errors obtained. The frequent errors encountered are:

  • #NUM! – this is obtain if the keyed in number arguments is below zero.
  • #VALUE! -  this happens if the keyed in value on the argument is not a valid numerical figure.

In order to lessen the possibility of encountering error, ensure that right syntax is used and right values are entered on the arguments.

Post comment