How To Use: GCD Function

The GCD function returns the greatest common divisor of two or more supplied integers. The greatest common divisor means the largest integer that divides two or more supplied integers without a remainder.

Syntax for GCD Function

=GCD(number,[number],……)

Argument

Number: The number arguments can be up to 255 numeric values for which you want to calculate the greatest common divisor.

If any of the supplied numbers are decimals, then these values will be truncated to integers.

I have created the infographics for the FLOOR Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.

Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.

Simply follow the instructions in the infographics below:

If any argument is non-numeric, this function returns the #VALUE! error.

If any argument is less than zero, then GCD returns the #NUM! error.

To learn other function like FLOOR, BASE, and DATE Functions, please click on the name of the function.

Additionally, you can download other accounting templates like Break Even Analysis Template, Sales Revenue Analysis Template and Invoice with GST Template from here.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.