# Nester If,AND and OR functions in excel 2007

Microsoft Excel 2007 home and student
March 8, 2010 at 17:12:18
Specs: Windows XP
 This question is driving me insane,can you help me?In column H, enter a formula to determine each employee's total family leave time(based on the family leave rules below).Family leave rules: 5 days for full-time employees who have worked for 1 or more years,3 days for full time employees who have worked less than 1 year OR for part-time employees who have worked more than 1.5 years, and 0 for everybody else.

See More: Nester If,AND and OR functions in excel 2007

#1
March 8, 2010 at 17:35:42
 Excel questions are best asked in the Office Software forum.But, try this: Since we don't have enough info to give an exact answer, here's a solution that you should be able to modify to suit your needs.Column A is Years WorkedColumn B is Employee Status (Full or Part Time)```Years Status 1.5 full 0.75 full 0.5 Part 0.05 full ```In Cell B7 enter this formula:=IF(AND(B2="full",A2>1),5,IF(AND(B2="full",A2<=1),3,IF(AND(B2<>"full",A2>=1.5),3,"0")))MIKEhttp://www.skeptic.com/

Report •

#2
March 8, 2010 at 18:26:38
 I'm still very confused...here are some more information:raw 6 is the first one with values in this table. Column B is "status", where FT is full-time, PT is part-time.Column C is "Date Hired"Column D is "years employed"Column E is "vacation leave"Column F is "used vacation leave"COlumn G is "remaining vacation leave"COlumn H is "family leave"So the first value is in B6 for status, C6 for date hired etc.

Report •

#3
March 8, 2010 at 18:59:45
 Ok, assuming row 6 has the data,B6 is your Full Time / Part Time D6 gives us the number of years employed What were looking for isFull Timer greater than 1 year gets 5Full Timer less than or equal to 1 year gets 3 Part Timer greater than or equal to 1.5 years gets 3Every one else gets zero=IF(AND(B6="FT",D6>1),5,IF(AND(B6="FT",D6<=1),3,IF(AND(B6="PT",D6>=1.5),3,"0")))MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
October 10, 2010 at 09:33:42
 I have the same case problem that i can not figure out, it is on how to computed the Vacation Summary Report Question 9. Can you help me?

Report •