View Single Post
  #2   Report Post  
tina
 
Posts: n/a
Default

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.