How To Calculate Ratio in Excel?

Short excel tutorial the explains you on how to calculate ratio between two numbers in excel.

Find Ratio Between Two Numbers in Excel

In mathematics, the term ratio defines the relationship between two numbers. It indicates how many times the first number is contained in the second number. For example, consider a fruit basket which contains eight apples and six pomegranates, then the ratio of apples to pomegranates is 8:6, which is equivalent to the ratio 4:3. The Greatest Common Divisor (GCD) function is used to calculate the ratio between two numbers in Excel. Learn here how to calculate ratio in Excel with screenshots.

How To Calculate Ratio in Excel?
Step 1:
Consider an Example, where you have 100 apples and 150 pomegranates.
Ratio Example
Step 2: Find the GCD between the apples and pomegranates in excel using the function =GCD(A2:B2)
Find Gcd
Step 3: Enter the formula in the required cell and tap enter button to calculate the GCD value.
Gcd
Step 4: You need to divide both the values with the GCD to find the ratio. Use the formula =(A2/C2&":"&B2/C2).
Ratio Calculation
Step 5: Enter the formula in the required cell and tap enter button to calculate the ratio between the two numbers in the Excel.
Ratio


Related Topics