Grading newly basis of Salary

Salehin31

New Member
Joined
Jan 27, 2013
Messages
40
hello frndz,

First of all thanx a lot that this forum helped me on every problem I faced earlier.

Now I have a prob.

We have a grading sheet to calculate the grade basis of Salary. In our office yearly increment is implement and Salary increased. Now I have to look each employee's grade on grading sheet. I want New salary grading will automatically calculate with Grading Sheet.

Old salary is 15600 & New salary 15800 previous grade was 335 & new grade will b 341

If salary is equal or less then salary colomn then grade will be on grade colomn

GradeSalaryNew Salary New Grade
335 15,588
336 15,625
337 15,663
338 15,700
339 15,738
340 15,775
341 15,813
342 15,850
343 15,888
344 15,925
345 15,963
346 16,000
347 16,038
348 16,075

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,122,409
Messages
5,595,973
Members
414,035
Latest member
billbumkins

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?

Disable AdBlock

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
Top