Percent and Rank formula in one cell

[T.R.]

I have a spreadsheet with formulas that calculates
percentages and rankings.
In cell C10 is the percentage formula =C9/C6.
In Cell C11 is the rank formula =RANK(C10,$C10:$O$10)
I want to combine the two formula into one cell. For
example on cell C10 I want to show 89.5% 2 (the percent
and the rank for that formula). Is there a way to show
these two formulas as one?


Thanks.

T.R.

 

[Guest]

try
=CONCATENATE(TEXT(C6/C9,"00.00%")," ",RANK(C10,$C10:$O$10))
Tina