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…
Tag: GCD function
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…