FORMULA, DAYS WORKED TO VACATION DAYS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John5835 - 31 Jul 2008 20:39 GMT

How would I do it the vacations are a little different, i.e.

after 1 year of work they receive 5 days vacations
for the 2nd, 3rd, and 4th year, vacation days equal 10 days
for the 5th, 6th, 7th, 8th, 9th year vacation days equal 15 days.
and then 10 years on, total vacation days equal 20.

1yr=5 days
2, 3, 4 yr= 10 days
5,6,7,8,9 yr = 15 days
10 and on = 20 days

Signature

thanks,
John

Reply to this Message

Mike H - 31 Jul 2008 21:21 GMT

No need for a new thread, check your old one

Mike

> How would I do it the vacations are a little different, i.e.
>
[quoted text clipped - 7 lines]
> 5,6,7,8,9 yr = 15 days
> 10 and on = 20 days

Reply to this Message

Ron Rosenfeld - 31 Jul 2008 21:28 GMT

>How would I do it the vacations are a little different, i.e.
>
[quoted text clipped - 7 lines]
>5,6,7,8,9 yr = 15 days
>10 and on = 20 days

Set up a two column table that looks like:

0    0
1    5
2    10
5    15
10    20

Then use this formula:

=VLOOKUP(YearsWorked,Tbl,2)

where Tbl refers to the range where you placed the two column table above.

--ron

Reply to this Message