Ratio's

[Tim]

What the best way to calculate ratio's in excel?

 

[Rick Rothstein]

Based on the information you provided, my best guess at an answer would
be... divide. I'm going to guess, though, that you were after something else
as an answer. Perhaps if you gave us an example of what you have and what
you want to do with it, someone here may be able to give you a better
response.

 

[Shane Devenshire]

Hi,

If Sales Persons figures are in cell A1 and total sales are in A10 then
=A1/A10 give the ration (*100 gives the percent).

You can also use the QUOTIENT function, although I see no reason to do so.

If you want to know how to display a ration as 1/16 or something along those
lines you should look at the Number format type of Fractions.

A little more info and we will probably have better answers.

 

[Tim]

let say you have use 300 turtles and 175 birds I want the ratio of the
turtles to the birds based on a 100. Other words 80/20 I just couldn't
figure it out. Mental block

Thanks

 

[Rick Rothstein]

The odds (no pun intended) are well against there being two **whole** numbers that will sum to 100 and have an **exact** fixed given ratio. If you would be satisfied with just the whole number ratio...

=(A1/GCD(A1,B1))&"/"&(B1/GCD(A1,B1))

where A1 contains the turtles and B1 contains the birds.

Note that the GCD is part of the Analysis ToolPak and requires that add-in to be active.

 

[Tim]

after I asked this question I realized the answer. I guess you could call it
a brain fart. Thank you for your help
The odds (no pun intended) are well against there being two **whole**
numbers that will sum to 100 and have an **exact** fixed given ratio. If you
would be satisfied with just the whole number ratio...

=(A1/GCD(A1,B1))&"/"&(B1/GCD(A1,B1))

where A1 contains the turtles and B1 contains the birds.

Note that the GCD is part of the Analysis ToolPak and requires that add-in
to be active.