How to Calculate Ratios in Excel

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

Comparing two amounts of the same units and determining the ratio tells us how much of one quantity is in the other. Two categories can be used to categorize ratios. Part to whole ratio is one, and part to part ratio is the other. The part-to-part ratio shows the relationship between two separate entities or groupings. For instance, a class has a 12:15 boy-to-girl ratio, whereas the part-to-whole ratio refers to the relationship between a particular group and the entire. For instance, five out of every ten people enjoy reading. As a result, the ratio of the part to the whole is 5: 10, meaning that 5 out of every 10 people enjoy reading.

Once ready, we’ll get started by utilizing real-world examples to show you how to calculate ratios in Excel.

Anatomy of GCD Functions

GCD Function

GCD(number1, [number2], …)

This function returns the largest common divisor of two or more integers. The biggest integer that divides both numbers 1 and 2 without leaving a residual is known as the greatest common divisor.

Calculate Ratios in Excel

Before we begin we will need a group of data to calculate ratios in Excel.

Step 1

First, you need to have a clean and tidy group of data.

Step 2

To find the ratio between data from Group A and Group B, we can simply insert this formula =A2/GCD(A2, B2)&”:”&B2/GCD(A2, B2).

Step 3

Once you press Enter, your formula will return the ratio for Group A and Group B.