Excel Ratio formula & Percentges

[Guest]

Hello everybody, I need a formula that will create a ratio out of two
numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30)
after it creates the ratios, then it turns it into a percentage (23%). Is
their one formula or a combination formula out their for this.

Thank you Group........

 

[Seahawk60B]

You can format the cell as a fraction, and it will revert to the lowest
common denominator -
Example: A1 = 30, B1 = 90, if C1=A1/B1 and is formatted as a fraction,
it will display 1/3.
So you've got your ratio expressed as a fraction (x/y) as opposed to
x:y

I'm not sure that's what you want, because your example doesn't make
sense - 25:90 is not 7:30 - it would be 8.3:30 or 5:18 as the LCD.

 

[Guest]

Great, thanks alot, if i go the fractional way, how do I turn that fraction
into a percentage thier after??

Thanks again

 

[Guest]

Great, thanks alot, if i go the fractional way, how do I turn that fraction
into a percentage thier after??

Thanks again

 

[David Biddulph]

If you've got your fraction in C1, you can put =C1 in cell D1, and format
that cell as percentage.