# Percentrank

#### Snehasandesh

##### New Member
how to calculate percent rank for employee salary with designation and no of year experienc as condition

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### ExcelElliott

##### New Member
Apologies if the example is a bit weird, but the idea is the same for the formula.

Let me know if there are any questions or concerns.

ABCDEFG
2IDDesignationYears of ExperienceSalary
3445533Senior Director20\$139,267.00
4309440Director20\$107,904.00
5119136Senior Director19\$120,382.00
6548464Vice President17\$176,110.00 DesignationVice President
7346154Senior Manager18\$109,233.00 Years of Experience17
8482527Director18\$110,771.00 Salary\$175,000.00
9677523Vice President17\$189,551.00 Percent Rank0.597
10747621Manager17\$95,595.00
11744377Vice President17\$170,735.00
12858280Senior Director16\$144,234.00
13362728Vice President17\$119,485.00
14225064Director16\$117,874.00
15242118Senior Manager14\$95,048.00
16159112Senior Director14\$140,049.00
17464903Director14\$116,064.00
18959997Manager13\$92,020.00

</tbody>
Salary Data (2)

Array Formulas
CellFormula
G9{=PERCENTRANK.INC(IF(Table134[Designation]=G6,IF(Table134[Years of Experience]=G7,Table134[Salary])),G8)}

</tbody>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

Replies
2
Views
142
Replies
6
Views
221
Replies
9
Views
128
Replies
2
Views
188
Replies
2
Views
131

1,195,992
Messages
6,012,740
Members
441,724
Latest member
Aalbid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back