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

Report •

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 Worked
Column 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:



Report •

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 •

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 is

Full Timer greater than 1 year gets 5
Full Timer less than or equal to 1 year gets 3
Part Timer greater than or equal to 1.5 years gets 3
Every one else gets zero



Report •

Related Solutions

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 •

Ask Question