I need some assistance. Here's what I'm trying to do:
I have a column with years of service for all our employees, say it's column
D. Column E needs to say what their accural rate for vacation time is
depending on their length of service. So if the years of service is less than
3, accural is 4.62. If it's between 3 and 7 years, accural rate is 5.54. If
it's between 7 and 14 years, accural rate is 6.46. If years of service are
greater then 14, accural rate is 7.39.
Here's what I have, but it's not working:
IF(D3<3,4.62),IF(3.1<D3<7,5.54),IF(7.1<D3<14,6.46) ,IF(14.1<D3,7.39)

Please help.
Thank you,
Dimple