How to Calculate the Ratio in Excel. To see the ratio enter this formula in cell E2 B2GCD B2C2C2GCD B2C2. In excel there is a format of finding Greatest Common Divisor which means when we select 2 values then compare with the third one it automatically considers the greatest value from which that comparative ratio value will get divided.
Watch this video to see how to use these formulas to calculate the ratios in Excel.
To calculate a ratio between 2 numbers in Excel you can use the GCD function Greatest Common Divisor or use the TEXT and SUBSTITUTE functions. GCD Function to Calculate Ratio in Excel. Calculate the ratio of two numbers in Excel using a formulaA ratio is a common way to compare amounts. Calculate a Ratio The GCD Method Click on Tools.