View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_61_] Peter[_61_] is offline
external usenet poster
 
Posts: 48
Default 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