One way (assuming your "Y" in the last line should have been a "C"):

=CHOOSE(IF(BY1="N",2*(M1=4),(M11)+2*(M13)+1),"N one","Single","Married"
,"Family")

In article ,
SCOOBYDOO wrote:

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