Hi,
I have a spreadsheet that has all employees with their Service Date (column AA), Salaries are in P, Current Date in AD2.

Every 5 years of employment staff receive an increase (1% for 5 years, 1.5% for 10, 2% for 15 & 2.5% for 20 & over).

In AI I am using =DATEDIF(AA6,$AD$2,"y") to determine the Service Years, AJ I am using =MOD(AI6,5)=0 to determine if AI is evenly divisible by 5 (True or False). I am now looking for a formula that will calculate the % increase based on 5, 10, 15, or 20+ years.

Thank you so much,

lisakay