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!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/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.

---

Closed Caption:

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 sign of colon or /a
mathematically it can be transformed
into a comparison
after the division of the numbers by the
smallest of thing
launch Excel and start a new file from
file new type the numbers you want to
calculate the ratio for into adjacent
cells
type in the formula equals brackets a
over B close brackets ampersand
quotation mark
: quotation mark ampersand and then in
brackets b over b where a and B are the
cell coordinates of your two numbers
congratulations you have learned how to
calculate the ratio in Excel
this was a how tech . TV tutorial
leave your comment below or contact us
by email thanks for watching