Using And/Or in IF statements

[Ronanm]

Can you use And/Or easily in VBA

I.E. Could you say if(And(A1 = 10,B1 =10),or(C1=5,C2=6,C3=7))

So A1 and B1 have to be true, and either of the "C" ranges could be true, for the whole thing to be true?

Cheers

 

[Jonmo1]

Try

=IF(AND(A1=10, B1=10,OR(C1=5,C2=6,C3=7)),do something for true, something for false)

 

[Ronanm]

Cheers Jon