How to Calculate the Ratio in Excel

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

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
   / ithowtovids   - our feed
  / howtechtv   - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

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.

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

Step 3. Type in the formula:

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

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

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