Grading newly basis of Salary

[Salehin31]

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

[TABLE="width: 287"]
<tbody>[TR]
[TD]Grade[/TD]
[TD]Salary[/TD]
[TD]New Salary[/TD]
[TD] New Grade[/TD]
[/TR]
[TR]
[TD]335[/TD]
[TD] 15,588[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]336[/TD]
[TD] 15,625[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]337[/TD]
[TD] 15,663[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]338[/TD]
[TD] 15,700[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]339[/TD]
[TD] 15,738[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]340[/TD]
[TD] 15,775[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]341[/TD]
[TD] 15,813[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]342[/TD]
[TD] 15,850[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]343[/TD]
[TD] 15,888[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]344[/TD]
[TD] 15,925[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]345[/TD]
[TD] 15,963[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]346[/TD]
[TD] 16,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]347[/TD]
[TD] 16,038[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]348[/TD]
[TD] 16,075[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Oeldere]

Why post the same question again?

Please reply.

http://www.mrexcel.com/forum/excel-questions/803894-sorting-grade-salary.html

 

[Salehin31]

I deleted this post. I think that was incomplete