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