Compounded condition in If statement

[jakopak]

I would like to use compound condition as follows:

If Range(a) = smth1 And Range(b) = smth2 And Range(c) <> smth3 Then
....
Else
....
End If

Is it somehow possible without nesting If statements?

[NeedForExcel]

Maybe

=IF(AND(A2="smth1",B2="smth2",C2<>"smth3"),D2,"")

in VBA

Please Login or Register  to view this content.

Change the Val Values as required and the ranges too

[jakopak]

Yes in VBA macro otherwise I would post it elswhere.

[NeedForExcel]

See post#2

[jakopak]

Thanks, now I know that it works as I thought. Strangely in my macro it evaluated only first two condtions. Is it somehow possible to compound condition like this?:

Please Login or Register  to view this content.