# How to Convert Percentage to Ratio in Excel

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.