Help with Years of Service formula....

  • Thread starter Thread starter Wild Bill
  • Start date Start date
W

Wild Bill

Yes, I would like to have some assitance on figuring how to formulate this
scenerio..

We have our Years of Service broke down like this...

Less than 5(years) .0412 10
5 .0453 11
7 .0494 12 etc..

this tells us that an employee who has less than 5 years in employment
will earn .0412 ours of vacation per hour or will earn 10 (12 hour days) of
vacation... actually if when they put in how many years of service, then
have it auto fill another cell with the (12 hour days per year)..
For instance if someone puts in 16 for the years of service, then "18"
will autofill in the cell. T"hanks bill
 
Hi
for the first row put a zero into column A and only use column A and B
for your data
Now use the following formula:
=VLOOKUP(lookup_value,A1:B10,2,TRUE)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prorated vacation formula required 4
vacation accrual formula 2
Vacation days from date of hire 15
Years of Service 3
Vacation accrual formula needed 2
Multiple conditions using greater than or less than. 1
Vacation Time calculation... HELP! 1
Need help with simple formula please 4

Back
Top