Duration: 1:58

13 views

0

Here's how to Calculate ratio in Microsoft Excel.

There are a few ways to calculate a ratio in Microsoft Excel. Here are two methods:

**Method 1: Using the GCD function**

The GCD function (Greatest Common Divisor) can be used to calculate the greatest common divisor of two or more numbers. Once you have the greatest common divisor, you can divide each number by the GCD to get the ratio.

For example, to calculate the ratio of 15 to 12, you would use the following formula:

```
=15/GCD(15,12)
```

This formula will return the value 5, which is the ratio of 15 to 12.

**Method 2: Using the TEXT and SUBSTITUTE functions**

The TEXT and SUBSTITUTE functions can also be used to calculate a ratio. The TEXT function can be used to format a number as a fraction, and the SUBSTITUTE function can be used to replace the forward slash with a colon.

For example, to calculate the ratio of 15 to 12, you would use the following formula:

```
=TEXT(15/12,"####/#####") & ":" & TEXT(12/15,"####/#####")
```

This formula will return the value "5:4", which is the ratio of 15 to 12.

Which method you use to calculate a ratio in Microsoft Excel depends on your preference. The GCD function is a more efficient way to calculate a ratio, but the TEXT and SUBSTITUTE functions are more versatile.