John,

I wouldn't use Choose because it will fail for someone with anything over 3
yrs service. Try this instead.

=IF(A1<=1,5,IF(A1<=2,10,15))

Mike

"John5835" wrote:

I need a formula to calculate employee vacation time from number of days
worked.
ex. after one year each employee receives 40 hour or 5 days of vacation
time, after two years they receive 10, and after three years on they have
earned 15 days of vacation time.

I cannot get my choose formula, =Choose(a1,10),5,10,15 to work
--
thanks,
John