About this tutorial:
Video duration: 00:08:01
Learn to easily calculate the ratio of two numbers in Excel with Excel formulas. A ratio tells you how much of one thing there is, compared to another thing. It’s a common way to compare amounts. For example to calculate the ratio of girls to boys or managers to team members.
There isn’t a single formula that does the ratio calculation in excel. Instead you need to divide each value with its greatest common denominator.
We’ll use the GCD Function in Excel to calculate the highest common factor. I’ll also show you how you can use the COUNTIF Function in Excel to extract ratios from a…