I am looking for an efficient formula to calculate pay rates based on years of service for 1500 records.
I have current pay rate and want to calculate projected pay rate for 2016, 2017, 2018, 2019 and 2020 using the following:
no pay rate increase for the first 4 years of service
6% pay rate increase at 5 years, 11 years, 16 years and 21 years
I calculate years of service based on hire date

My current formula =if(and($n2>=5, $n2<=10),($t2*.06)+$t2,0)
n2 = years of service
t2 = pay rate

One of my challenges is how to modify the formula to increase years of service by 1 for; 2016, 2017, 2018, 2019, 2020

Thanks for any and all suggestions