**4 Formulas to Calculate Ratio in Excel**

Simple Divide Method

GCD Function

SUBSTITUTE and TEXT

Using Round Function

**1. Calculate Ratio by using Simple Divide Method**

We can use this method when the larger value is divisible with the smaller value. In the below example, we have value 10 and 2, where 10 is divisible with 2.

So you can use this method here. Insert the below formula into the cell and hit enter.

=A2/B2&”:”&”1″

**here's how this formula works...**

In this formula, we have divided 10 with 2 which gives you 5 in return. So now we have 5 instead of 10 by dividing with 2. And on the other side, we have used 1 instead of 2.