What's the EXCEL formula for vacation days?

B

beardoweirdo

New member
Joined
Mar 4, 2011
Messages
0
Reaction score
0
Points
0
"enter a formula using nested IF & AND functions to determine the number of vacation days (based on rules below) each employee is eligible for based on employee's status & length of time employed."

15 days for full time employees who have worked 4 or more years
10 days for full time employees who have worked 2 years but less than 4
5 days of full time employees who have worked 1 year but less than 2
0 for everyone else

So I know my variables: Status, and Years of Employment, I just dont know how to put it into a single IF Formula....Help!
 
Steele has a good answer. However, if you really need the AND function, use this formula:

=IF (AND (B1="Full Time",B2>=4), 15, IF (AND (B1="Full Time",B2>=2), 10, IF (AND (B1="Full Time",B2>=1),5,0)))

The formula assumes Status and Years are in B1 and B2, change accordingly for your needs.

--Spaces are because Y!A cuts off long strings.
 
Back
Top