Operators/if etc
Can any one help?!
I am trying to say:
If cell [blah,blah] = Jack or Paddy then cell [blah, blah] should =
Jazz
The code I've got is:
If Cells(40, 1).Value = "Jack" Xor "Paddy" Xor "Andy" Xor "Gary" Then
Cells(41, 1).Value = "Jazz"
Else
Cells(41, 1).Value = "Blues"
End If
Needless to say that it doesn't work, so if any of you experts in
google land have any ideas then I'd be very grateful to hear them.
Thanks,
Peter
|