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
<tbody>
</tbody>
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
Grade | Salary | New 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>