And/Or

[cherokee]

Trying to use AND OR together.
IF(AND(A1=5,B1=10)) OR IF(AND(A1=30,B1=10),A1,"")

This obviously doesn't work. The OR is to allow a different choice for A1 but B1 remains the some.

A1 is a 10 or 30 and B1 is constant. I need two variables for A1 to agree with B1 resulting in a TRUE

 

[Johnny Thunder]

=IF(OR(AND(A1=5,B1=10), AND(A1=30,B1=10)), A1, "")

Something like this.

 

[AhoyNC]

=if(and(or(a1=5,a1=30),b1=10),a1,"")

 

[cherokee]

Thanks AhoyNC, his works really good.

 

[AhoyNC]

You're welcome. Thanks for the feedback.