To convert a percentage to a ratio, you can use the following steps:

**1.** Remove percentage symbol

**2.** Divide value by 100

**3.** Convert Fraction to Reduced Fraction

For example, suppose you would like to convert **22%** to a ratio.

First, convert 22% to **22**.

Then, convert 22 to **22/100**.

Lastly, write the reduced fraction as **11/50**.

You can use the following formula in Excel to convert a percentage to a ratio:

=SUBSTITUTE(TEXT(A2,"?/??"),"/",":")

This particular formula converts the percentage in cell **A2** to a ratio.

For example, if cell **A2** contains

The following example shows how to use this formula in practice.

**Example: Convert Percentage to Ratio in Excel**

Suppose we have the following column of percentages in Excel:

Suppose we would like to convert each percentage to a ratio.

We can type the following formula into cell **B2** to do so:

=SUBSTITUTE(TEXT(A2,"?/??"),"/",":")

We can then click and drag this formula down to each remaining cell in column B:

Column B displays each percentage in column A as a ratio.

For example:

**22**% is equivalent to a ratio of**11:50**.**50**% is equivalent to a ratio of**1:2**.**100**% is equivalent to a ratio of**1:1**.**25**% is equivalent to a ratio of**1:4**.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Find the Top 10% of Values in an Excel Column

How to Calculate Cumulative Percentage in Excel

How to Multiply Column by a Percentage in Excel