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
 

=A1/A2 and format as percent?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Six Sigma Blackbelt" wrote in
message ...
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........