I have the follwing conditions:

If X = "*" And Z = "*" Then
formula here
ElseIf X = "*" And Z = 1 Or Z = 2 Or Z = 3 Then
formula here
ElseIf X = "*" And Z <> 1 Or Z <> 2 Or Z <> 3 Or Z <> "*" Then
formula here
ElseIf X <> "*" And Z = 1 Or Z = 2 Or Z = 3 Then
formula here
ElseIf X <> "*" And Z <> 1 Or Z <> 2 Or Z <> 3 Or Z <> "*" Then
formula here
EndIf

is ther any conflict or something wrong here?!

I find in some cases my formula do not work.

Thanks