Excel Ratio formula & Percentges
 

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........

Excel Ratio formula & Percentges
 

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.


Six Sigma Blackbelt wrote:
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........

Excel Ratio formula & Percentges
 

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

Thanks again

"Seahawk60B" wrote:

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.


Six Sigma Blackbelt wrote:
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........

Excel Ratio formula & Percentges
 

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

Thanks again

"Seahawk60B" wrote:

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.


Six Sigma Blackbelt wrote:
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........

Excel Ratio formula & Percentges
 

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

"Six Sigma Blackbelt" wrote in
message ...
Great, thanks alot, if i go the fractional way, how do I turn that
fraction
into a percentage thier after??

Thanks again

"Seahawk60B" wrote:

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.

Six Sigma Blackbelt wrote:
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........