I would like a formula which would help me calculate payout based on the following business rules.
from the age 20 to 21(both included) - 0.5 week’s pay for each completed year of service
22 - 40 (both included) years of age - 1 week’s pay for each completed year of service
41 and above years of age - 1.5 weeks’ pay for each completed year of service
A2 has my present age = 52
B2 has my yrs of completed service = 19
C2 has my one weeks pay = 290
Can any body help ? The calculation is step based so the period between 22-40 will be calculated at 1 weeks pay and the years beyond (so in my case 12 yrs fall in 41+ category and 7 yrs in the 22-40 category.
Please help me ..
THanks Pankaj
from the age 20 to 21(both included) - 0.5 week’s pay for each completed year of service
22 - 40 (both included) years of age - 1 week’s pay for each completed year of service
41 and above years of age - 1.5 weeks’ pay for each completed year of service
A2 has my present age = 52
B2 has my yrs of completed service = 19
C2 has my one weeks pay = 290
Can any body help ? The calculation is step based so the period between 22-40 will be calculated at 1 weeks pay and the years beyond (so in my case 12 yrs fall in 41+ category and 7 yrs in the 22-40 category.
Please help me ..
THanks Pankaj