Hi all,
I have a spreadsheet that looks like the following
<tbody>
</tbody>
I was wondering if there was a formula i could put in a new column that would let me know which Benchmark percentile the value in column A falls within. Also, is there a way to perform an "IFS" statement to say "if the wages in column in A are less than then the 10th% then say "less than 10%", if the value in column a is between 10th % and 25th% then say "10th-25th"" and so on?
Thank you!
I have a spreadsheet that looks like the following
Benchmark | Benchmark | Benchmark | Benchmark | Benchmark | ||
Wages | 10th | 25th | 50th | 75th | 90th | |
65,000 | 100,000 | 200,000 | 300,000 | 400,000 | 500,000 | |
300,000 | 100,000 | 250,000 | 298,000 | 350,000 | 400,000 | |
180,000 | 50,000 | 60,000 | 70,000 | 120,000 | 200,000 |
<tbody>
</tbody>
I was wondering if there was a formula i could put in a new column that would let me know which Benchmark percentile the value in column A falls within. Also, is there a way to perform an "IFS" statement to say "if the wages in column in A are less than then the 10th% then say "less than 10%", if the value in column a is between 10th % and 25th% then say "10th-25th"" and so on?
Thank you!