Nested IF and AND formula

[carrie08]

--
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]=2>4,10,IF([Years Employed]=1<2,5,0))).

What am I not doing right??

 

[Billy Liddel]

Carrie

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

where A16 is status and B16 is the years employed.

Regards
Peter

 

[John C]

If you would like to get fancy....

A2 is Status
B2 is Years Employed
C2: =IF(A2<>"FT",0,MIN(5+(INT(ROUNDUP(B2/2,0))-1)*5,15))

 

[carrie08]

Thank you so much. My formula now works.
--
kae

Carrie

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

where A16 is status and B16 is the years employed.

Regards
Peter

--
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]=2>4,10,IF([Years Employed]=1<2,5,0))).

What am I not doing right??