Nested IF and AND formula
 

--
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

Nested IF and AND formula
 

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

Nested IF and AND formula
 

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))
--
John C


"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

Nested IF and AND formula
 

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


"Billy Liddel" wrote:

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