FORMULA, DAYS WORKED TO VACATION DAYS
 

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

--
thanks,
John

FORMULA, DAYS WORKED TO VACATION DAYS
 

No need for a new thread, check your old one

Mike

"John5835" wrote:

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

--
thanks,
John

FORMULA, DAYS WORKED TO VACATION DAYS
 

On Thu, 31 Jul 2008 12:39:01 -0700, John5835
wrote:

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

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