IF and AND function

[depaul]

Hello,
Please help me with this problem
How to use nested IF and AND function on problem below

For Vacation
- 15 days for Full-time employees who have worked 1 or more years
- 10 days for Full-time employees who have worked 2 years but less than 4 years or for Part-time employees who have worked more than 1.5 years
- 0 years for everyone else.

** Using nested IF and AND functions to determine the numbers of vacation days (based on the Vacation rules described above) each employee is eligible for based on the employee's Job Status and on Length of Time Employed.

For few days, I couldn't figure it out how to do it... Please help
Big Thanks,
T

 

[texasalynn]

Welcome to MrExcel board....

try this

Excel Workbook
	A	B	C	D	E
25	3/11/2011
26	Name	Date of Hire	Full Time	Vacation Time
27	John Smith	5/1/1998	Y	15
28	Jerry Johns	6/2/2010	Y	0
29	Mary Jones	9/2/2009	N	10
30	Paul Quince	1/2/2011	Y	0
Sheet1

Excel 2003

Cell Formulas
Range	Formula
A25	=TODAY()
D27	=IF(AND(DATEDIF(B27,$A$25,"Y")>=2,DATEDIF(B27,$A$25,"Y")<=4,C27="Y"),10,IF(AND(DATEDIF(B27,$A$25,"Y")>=1,C27="Y"),15,IF(AND(DATEDIF(B27,$A$25,"Y")>=1,C27="N"),10,0)))

copy the formula in D27 down