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

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