Carrie

Try
=IF(AND(A16="FT",B16<=2),5,IF(AND(A16="FT",B16<=4) ,10,IF(AND(A16="FT",B164),15,0)))

where A16 is status and B16 is the years employed.

Regards
Peter

"carrie08" wrote:


--
Could you please help me with this formula. I am trying to use a nested IF
and AND
formula to calculate the vaction days for full time employess with different
service years. I need to nest 3 different answers. Here is my formula that
keeps getting rejected:

=IF(And([Status]="FT",[Years Employed]=4,15,IF([Years
Employed]=24,10,IF([Years Employed]=1<2,5,0))).

What am I not doing right??
--
kae