The criteria is:

1-4yrs is 120/hrs

5-14yrs is 160/hrs

15+ is 200/hrs

Now I have a column with the number of days (B1) the employee has been employeed. In another column (A1) Is where I want the rate to show up using the if statement.

i.e. IF B1 is between 0-1460/days then its 120,

IF between 1461-5110/days then its160, &

IF greater then 5110/day its 200