How to Calculate the Ratio in Excel


In this tutorial you will learn how to calculate ratio in Excel

A comparative function, the ratio value is the relationship between two or more numbers and is shown by the signs of : or /
Mathematically, it can be transformed into a comparison after the division of the numbers by the smallest of them.

Prerequisites: Microsoft Excel

Step 1. Launch Excel and start a new file from File- New.

launch Excel

Step 2. Type the numbers you want to calculate the ration for in two adjacent cells.

type in values

Step 3. Type in the formula:

=INT (A/B)&” : ”&(B/B), where

A and B are the cell coordinates of your two numbers.

enter formula

Result: Congratulations, you have learnt how to calculate the ratio in Excel.