Thread: IF Function
View Single Post
  #1   Report Post  
Benny
 
Posts: n/a
Default IF Function

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