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>
