find greatest common diviser in Excel

Q84. I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

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 set up a drop down list?

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

3) how to write a formula in Excel

4) How can I loop through all ActiveX checkboxes in WorkSheet and set them to Unchecked status?

5) How can I get users to select a file for processing using my macro?

6) Find and count instances of a character in a string in Excel

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

8) How can I set up a dynamic named range that expands automatically when new items are added to the list?

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

10) 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?

11) How can I set up ListBox using VBA to allow users to select multiple values?

12) Is there any way I can see more region of my WorkSheet?

13) Split one long column into multiple smaller columns in Excel

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

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