Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the "IN" function in Excel
I'm trying to evaluate if a cell value resides in a list
of values. I'm trying to use the IN function similar to how I use it in Access but it keeps erroring out. Can anyone help me understand what I'm doing wrong? Here is the sample code I'm using. Many Thanks! If Cells(1, b).value in ("0309","0713","0728","0730","0741","1020","1022") , then MsgBox "test" End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |