I am trying to figure a formula for the following:
employees with up to 1 yr get 5 days vacation
the second year they get 5 more
the third year and forward get one more additional day
How do I pose the formula?
thank you!
I am trying to figure a formula for the following:
employees with up to 1 yr get 5 days vacation
the second year they get 5 more
the third year and forward get one more additional day
How do I pose the formula?
thank you!
You should make a table for the vacation time based on years worked and then use a Vlookup function to get the amount.
Here is the sample function:
=VLOOKUP(D2,A2:B21,2)
I included a workbook sample. Adjust the value for the Years column to get the type of calculation that you want. For instance, 1 equals 10 right now because, if they worked there for 1 year, they are then elegible for 10 days of vacation. Adjust the values to suit your business needs.