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.

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 fullIn 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")))

MIKE

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.

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

=IF(AND(B6="FT",D6>1),5,IF(AND(B6="FT",D6<=1),3,IF(AND(B6="PT",D6>=1.5),3,"0")))MIKE

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?

Ask Your Question

Weekly Poll

Do you think Microsoft Office is too confusing to use?

Discuss in The Lounge

Poll History