Find greatest common divisor in Excel

To do it in Excel, here is the answer:

a) Enter the formula =GCD(14,12) as shown below where 14 and 12 are the dimensions of the room.

GCD stands for "Greatest Common Divisor" and returns the largest positive integer that divides both 14 and 12 (that is fed as arguments in this case).

excel find greatest common divisor


You can find similar Excel Questions and Answer hereunder

1) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

2) Given a raw data Table, how can I find the value of a field for a specific value of another field?

3) How can I identify all cells with Data Validation in my WorkSheet?

4) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

5) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

6) How can I find the least common multiple using Excel?

7) How can I identify the cells that are dependent on a particular cell?

8) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

9) How can I find the last used cell in a Column in VBA?

10) How can I identify all cells with Conditional Formatting in my WorkSheet?


Here the previous and next chapter