What Is Ratio? In mathematics, a ratio is a relationship between two numbers of the something or it shows the comparative of two or more values. Ratios can be shown in different ways. Using the ":" or "/" to separate.

Example :- If there is 1 Pen and 3 Notepad you could write the ratio as: [3:1 or 3/1] Means for 1 Pen there is 3 Notepad. You can try the below formulas to calculate ratio in Excel.

Thank you for the simple explanation and the variety of formulas

Reply

Tony

09/04/2014 7:09am

Can you give me a formula to find the two values that would be calculated by a ratio? For example, distribute 120 apples to two people at a ratio of 5:1. The answer is Person 1 gets 100 apples, person 2 gets 20 apples. I am looking at having the total number and using a ratio to find the result??

Reply

Ayubu

09/04/2014 7:58am

Good, but how to round off if the numbers are in decimal places.

Reply

thanks

10/08/2014 4:09pm

Thanks for the info. For rows 6-8, could you just put ":1" at the end instead of the (b6/b6)?

Reply

Leave a Reply.

Author

All blog's are written by Excel Do Easy That help People to learn new trick's on Microsoft Excel.