|
|
| *Ostroff, Fair and Company>>>Other - Business & Finance |
How do I write a formula to calculate how much annual leave each employee earns based on years of service.? |
I need to know how to write the formula for empl that earn annual leave based on years of service: For ex: up to 5 years earn 4 hours leave 5 yrs earn 5 hours leave 10 yrs earn 6 hours leave etc. =if(years>5,4,if(and(years<10,... Is this for an Excel worksheet? If so there are numerous ways to create formulas, depending on how creative you want to be. One simple example... IF("Years of Service" > 0, IF("Years of Service" < 5, 4, IF("Years of Service" <= 5, 5, IF("Years of Service" <= 10, 6)))) if you have a copy of your local labor unions contracts, the formulas are already written down, and that is a highly negotiable changeable item from one trade or craft to another one employer to another, what works well for one may or may not work elsewhere ie. in our craft, its a graduated system of time merits until ten years, then thereafter its 21 days per year, with an allowable accumulation up to 40 days use it or lose it by 1/1 each year. even in the military, they are allowed to accumulate up to 60 days unless in a combat zone, then it must be all liquidated upon return home. in a lot of places some employers balk at any time anywhere, and those jobs are always posted promently in the daily papers I think you a missing some information. Only 4 hours of leave after 5 years of service does not sound reasonable. Do you mean 4 hours annual leave for each month worked during the year? Are you trying to write a spreadsheet formula or just with pencil and paper? For a spreadsheet you could use "if" statements or a table look-up. If you are taking about pencil and paper try something like this. Hours earned per month times number of months worked. |
| Tags |
| Other - Business & Finance Other Taxes United States Taxes United Kingdom Taxes Spain Taxes |
Finance Categories--Copyright/IP Policy--Contact Webmaster |