Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operators/if etc
Peter
You could do it with a Select Case structu Select Case Cells(40, 1).Value Case "Jack", "Paddy", "Andy", "Gary" Cells(41, 1) = "Jazz" Case Else Cells(41, 1) = "Blues" End Select If you wanted to use If you'd need to do it like: If Cells(40,1) = "Jack" Or Cells(40,1) = "Paddy" Or ... etc which is long-winded. You don't want to use Xor. Richard Peter wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operators/if etc
Hi Peter,
You need to specify the cell again, so your code would be: If Cells(40, 1).Value = "Jack" Or Cells(40, 1).Value = "Paddy" Or Cells(40, 1).Value = "Andy" Or Cells(40, 1).Value ="Gary" Then Cells(41, 1).Value = "Jazz" Else Cells(41, 1).Value = "Blues" End If A more elegant way and possibly an easier way is to use a select statement, this would look like: Select Case Cells(40,1).Value Case "Jack", "Paddy", "Andy", "Gary" Cells(41, 1).Value = "Jazz" Case "Peter" Cells(41, 1).Value = "R & B" Case Else Cells(41, 1).Value = "Blues" End Select So you select your case in this case Cells(40,1).value and for each case you are just saying if it equals this then do this, very similar to an IF statement. I hope this helps, James Peter wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operators/if etc
Works like a charm,
Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operators/if etc
Works like a charm,
Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |