Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where are Bitwise Operators | Excel Worksheet Functions | |||
Comparison Operators | Excel Programming | |||
greater than but less than operators for VBA | Excel Programming | |||
Operators With Times | Excel Discussion (Misc queries) | |||
Unary operators | Excel Worksheet Functions |