Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
I need help...I'm trying to find a formula that will figure how many days and
employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
check datedif funcion on the help it will help you a lot;
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
Thanks, but I've already got a formula to fiqure how many years each employee
has, I'm having trouble writing a formula that will calculate all the given information and then telling me how many days they should be off. If this can be done in the "Datedif" function, I don't know how to do it. "Marcelo" wrote: check datedif funcion on the help it will help you a lot; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
try it assuming the number of years is on the D17 cell.
IF(D17=25,30,IF(D17=20,25,IF(D17=15,20,IF(D17= 8,15,IF(D17=3,10,IF(D17=2,5)))))) assuming the number of years is on the D17 cell. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: Thanks, but I've already got a formula to fiqure how many years each employee has, I'm having trouble writing a formula that will calculate all the given information and then telling me how many days they should be off. If this can be done in the "Datedif" function, I don't know how to do it. "Marcelo" wrote: check datedif funcion on the help it will help you a lot; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
Thank you. I copied your formula and it worked perfectly. Thanks again from
Florida! "Sandy Mann" wrote: One way: =LOOKUP(C12,{1,3,8,15,20,25},{5,10,15,20,25,30}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skeeter man" wrote in message ... Thanks, but I've already got a formula to fiqure how many years each employee has, I'm having trouble writing a formula that will calculate all the given information and then telling me how many days they should be off. If this can be done in the "Datedif" function, I don't know how to do it. "Marcelo" wrote: check datedif funcion on the help it will help you a lot; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
You're welcome. Thanks for the feedback.
-- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skeeter man" wrote in message ... Thank you. I copied your formula and it worked perfectly. Thanks again from Florida! "Sandy Mann" wrote: One way: =LOOKUP(C12,{1,3,8,15,20,25},{5,10,15,20,25,30}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Skeeter man" wrote in message ... Thanks, but I've already got a formula to fiqure how many years each employee has, I'm having trouble writing a formula that will calculate all the given information and then telling me how many days they should be off. If this can be done in the "Datedif" function, I don't know how to do it. "Marcelo" wrote: check datedif funcion on the help it will help you a lot; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
I think you'll find, Marcelo, that DATEDIF has been missing from Excel help
for versions after 2000 (unless it's still in the Brazilian version?). There is an explanation of the function at http://www.cpearson.com/excel/datedif.aspx (previously http://www.cpearson.com/excel/datedif.htm). -- David Biddulph "Marcelo" wrote in message ... check datedif funcion on the help it will help you a lot; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Skeeter man" escreveu: I need help...I'm trying to find a formula that will figure how many days and employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas Not Working in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Formulas ? | Excel Discussion (Misc queries) | |||
Automated Formulas in Excel 2003 | Excel Discussion (Misc queries) | |||
Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
Excel 2003 formulas | Excel Discussion (Misc queries) |