Benny

One way.

In C1:

=IF(B1=0,"Non-Comp",IF(AND(B1=1,OR(A1={1,2,3})),"Comp","Not defined"))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Benny" skrev i en meddelelse
...
I need get results in a new cell if 2 criterias from different cella are
met.
i.e
If A1= 1 or 2 or 3
and B1=1 then C1="Comp"
but if B1=0 then C1="Non-Comp"

Thanks for your help
--
Benny