I have a data in sheet1. I have calculate the salary for all the employee using below code
In the above code there is no problem for calculating D.A & H.R.A and only problem for calculating T.A for all the employee.Please Login or Register to view this content.
Procedure for calculating T.A is:
1. if grade pay 1800 to 1900 then the T.A is =900+D.A RATE
2. if grade pay 2000 to 4200 then the T.A is =1800+D.A RATE
2. if grade pay 5400 and above then the T.A is =3600+D.A RATE
Kindly give the solution for calculating T.A
Bookmarks