Want to learn simple formulas on how to ** calculate a ratio from two numbers in Excel*? This post will give you an overview of how to do so using the **GCD function* in Excel. Utilize the below-mentioned formulas!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- To calculate a ratio from two numbers in Excel, use the below formula.
=num1/[GCD](https://geekexcel.com/how-to-use-excel-gcd-function-in-office-365-with-examples/)(num1,num2)&":"&num2/[GCD](https://geekexcel.com/how-to-use-excel-gcd-function-in-office-365-with-examples/)(num1,num2)
Syntax Explanation
- GCD – This GCD function returns the greatest common divisor of two or more integers.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Division (/) – It is used for dividing values or numbers.
Practical Examples
Use the following steps to calculate a ratio from two numbers in Excel.
- For instance, you need to create a sample data in Excel.
Sample data
- Then, to generate the ratio of two numbers to each other, you have to use the following formula in formula bar.
=B4/[GCD](https://geekexcel.com/how-to-use-excel-gcd-function-in-office-365-with-examples/)(B4,C4)&":"&C4/[GCD](https://geekexcel.com/how-to-use-excel-gcd-function-in-office-365-with-examples/)(B4,C4)
Use the Formula
- Now, you need to Hit the Enter key to get the result ** in the **cell E4.
Result in cell E4
- Finally, you have to press Ctrl+ D key to get the results in other columns.
Output
Conclusion
Hope you like this article on how to calculate a ratio from two numbers in Excel. If you have any doubt regarding this article or have any other questions related to Excel, let me know in the comment section below.
Thank you so much for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!
Continue Reading:
Top comments (0)