How to Calculate the Ratio in Excel
video description
Date: 2023-07-08
Related videos
Comments and reviews: 6
Game
This formula doesn't even make sense. Why would you divide B by B? You would always just end up with one. At that point you might as well just put one in parenthesis. Dividing two numbers and then putting a colon in between it and a one doesn't make it a proper ratio either. The formula should be: =A1/GCD(A1, B1)&: &B1/GCD(A1, B1)
reply
This formula doesn't even make sense. Why would you divide B by B? You would always just end up with one. At that point you might as well just put one in parenthesis. Dividing two numbers and then putting a colon in between it and a one doesn't make it a proper ratio either. The formula should be: =A1/GCD(A1, B1)&: &B1/GCD(A1, B1)
reply
pete
1sahorton I use the following formula =ROUND(A/GCD(A: B, 0) &: & ROUND(B/GCD(A: B, 0). the 0's can be used to set the decimal place. however if you don't want to round the number you need to remove that bit out of my example: )
reply
1sahorton I use the following formula =ROUND(A/GCD(A: B, 0) &: & ROUND(B/GCD(A: B, 0). the 0's can be used to set the decimal place. however if you don't want to round the number you need to remove that bit out of my example: )
reply
Agimaso
To limit the number of decimals, either use a rounding formula (INT or variation of ROUND) or format the cell to contain only that number of decimals. The formulas will change the answer, formatting will not
reply
To limit the number of decimals, either use a rounding formula (INT or variation of ROUND) or format the cell to contain only that number of decimals. The formulas will change the answer, formatting will not
reply
pete
Make sure to have Tools > Addins > Analysis ToolPak & Analysis ToolPak - VBA. enabled otherwise you will get NAME? returned values in your cells.
reply
Make sure to have Tools > Addins > Analysis ToolPak & Analysis ToolPak - VBA. enabled otherwise you will get NAME? returned values in your cells.
reply
Demric
Thank you, we programmers can also use this to compute ratios in our programming language. Great Help!
reply
Thank you, we programmers can also use this to compute ratios in our programming language. Great Help!
reply
Simon
When you use numbers as an example 0 and 3, the ratio comes out 0: 1 but its not quite right or is it?
reply
When you use numbers as an example 0 and 3, the ratio comes out 0: 1 but its not quite right or is it?
reply
Add a review, comment
Other channel videos
