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.

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.