Ratio: In simple mathematics, the relationship or comparison between two or more numbers is known as ratios. Ratios are normally written as ":" to show the connection between two numbers, for instance. If there were 2 red balls and 3 blue balls on the table, you could write their ratio as: [2:3]
Unfortunately, there is no systematic way to calculate the ratio, but there is an easy way to do the same. You can try the below formulas to calculate the ratio in Excel.
How to calculate ratio using ROUND function?
The ROUND function in Excel is used to trim down (reduce) a given value to a specific number of decimal places.
= ROUND (Number, Num_digits )
The ROUND function will round up or down depending on whether the last digit is greater than or less than 5.
The CONCATENATE function joins text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person's first name in cell A1 and a person's last name in cell B1, you can combine the two values in another cell by using the following formula:
= CONCATENATE (A1," ", B1)
The second argument in this example (" ") is a space character. You must specify any spaces or punctuation that you want to appear in the results as an argument that is enclosed in quotation marks.
NOTE: You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items.
For example, =A1 & B1 returns the same value as =CONCATENATE (A1, B1).
How to calculate ratio using GCD function?
There is also a method using the GCD function. GCD stands for Greatest Common Divisor.
Finding the Greatest Common Divisor is the basis of the formula. To calculate the ratio, you just need to divide two numbers by their GCDs.
The formula I used in the example is:
=A3/GCD(A3,B3)&" : "&B3/GCD(A3,B3)
Calculating the ratio using the GCD function is the most convenient method.
How to calculate ratio using text functions?
I'm not sure if you will make me a serious. There is also a third method of finding the ratio in Excel. This is rather a bonus for this Excel tutorial lesson. I doubt anyone will use that, but it is working fine.
The formula I used: =SUBSTITUTE(TEXT(A3/B3,"#####/#####"),"/",":")
I don't like calculating ratios using text functions. I am rather old-fashioned and use Excel more for calculations and financial staff than to manipulate strings through text functions.
When calculating ratios in Excel, it's important to be mindful of potential errors and to double-check your calculations. It's also important to keep in mind that ratios are always expressed as a relationship between two values, so the units of measurement should be consistent for both values in the ratio calculation.