=IF(AND(OR(M2=1,M2=2,M2=3),B2="N"),"None",IF(AND(O R(M2=2,M2=3),B2="C"),"Sing
le",IF(M2=4,IF(B2="N","Married","Family"))))

--
HTH

Bob Phillips

"SCOOBYDOO" wrote in message
...
Hi, I need help with the following please:

Col M = Grade (values 1 - 4) and column BY is populated with either a C or
an N. I need a formula to work out entitelement based on the following:
If Grade = 1, 2 or 3 and BY = N then the answer is None
If Grade = 2 or 3 and BY = C then the answer is Single
If Grade = 4 or above and BY = N then the answer is Married
If Grade = 4 or above and BY = Y then the answer is Family

Tahnks in advance ; )