How do I enter conditions

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

How do I enter conditions like:

If A1 is <0.2 and A2 is >or = 0.2 then A3=Negative

If A1 is >0.2 but <2.0 and A2 is Anything then A3 is IND.

If A1 is > or = 2.0 and A2 is Anything then A3 is Positive.



and get them to work? I would need all 3 conditions in a single cell.
Is this possible?
 
In A3, enter:

=IF(AND(A1<0.2,B1>=0.2),"Negative",IF(AND(A1>0.2,A1<2),"Ind",IF(A1>=2,"Posit
ive","Case Not Handled")))


Mangesh
 
=IF(AND(A1<0.2,A2>=0.2),"Negative",IF(AND(A1>0.2,A1<2),"IND",IF(A1>=0.2,"Pos
itive","")))

Vaya con Dios,
Chuck, CABGx3
 
Back
Top