IF Function

[Benny]

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

 

[Leo Heuser]

Benny

One way.

In C1:

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

 

[Benny]

Thanks, Leo.

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.

 

[Leo Heuser]

You're welcome, Benny.