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