Board index » Excel » IF Function

Excel10
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


-

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" <Benny@discussions.microsoft.com>skrev i en meddelelse



-

Thanks, Leo.



"Leo Heuser" wrote:

You're welcome, Benny.





"Benny" <Benny@discussions.microsoft.com>skrev i en meddelelse



-