Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percent Rank | Excel Worksheet Functions |