Short excel tutorial the explains you on how to calculate 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.
Step 2: Find the GCD between the apples and pomegranates in excel using the function =GCD(A2:B2)
Step 3: Enter the formula in the required cell and tap enter button to calculate the GCD value.
Step 4: You need to divide both the values with the GCD to find the ratio. Use the formula =(A2/C2&":"&B2/C2).
Step 5: Enter the formula in the required cell and tap enter button to calculate the ratio between the two numbers in the Excel.