Using AND & OR in VBA

[mikeymay]

In Excel a formula can be built to establish if a number of conditions are true or false such as
=IF(AND(A1=1,OR(A2=1,A3=1)),TRUE,FALSE)

So if A1=1, A2=1 & A3=0 then the result would be TRUE
Similarly if A1=1, A2=0, A3=1 then TRUE
Or if A1=1, A2=0, A3=0 then FALSE

How would this translate to VBA?

TIA

 

[RoryA]

Like this:

If Range("A1").Value2 = 1 And (Range("A2").Value2 = 1 Or Range("A3").Value2 =1) Then
' True part
Else
' False part
End If

 

[mikeymay]

Thanks RoryA