Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: GCD function

GCD function: Description, Usage, Syntax, Examples and Explanation

What is GCD function in Excel? GCD function is one of the Math and Trig functions in Microsoft Excel that returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. Syntax of GCD function GCD(number1, [number2], …) The GCD function syntax has the following…

Calculate a ratio from two numbers in Excel

To generate the ratio of two numbers to each other (e.g. 4:3, 16:9, etc.), you can do using division, the GCD function, and concatenation. In the formula  of the formula below num1 represents the first number (the antecedent) and num2 represents the second number (the consequent). Formula =num1/GCD(num1,num2)&”:”&num2/GCD(num1,num2) Explanation In the example, the active cell contains this formula: =B4/GCD(B4,C4)&”:”&C4/GCD(B4,C4) Note: the GCD…