Percent and Rank formula in one cell

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.

i would likely just concatenate the two together in a third column...

=concatenate(C10, " - ", C11)
=89.5% - 2

there may be another way, though.

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