| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested AND OR expressions
On Sat, 5 Jun 2010 19:44:24 +0100, Colin Hayes wrote:
HI I need to express something in VBA , and am having trouble with it. I need to say this : IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 , OTHERWISE PUT J1 Can someone assist with some code to make this happen , please? Grateful for any help. The most straightforward way, I think, is =IF( AND( OR(E1="1bx",E1="2bx","E1="3bx"), J1=11), 1, J1) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get rid of with regular expressions | Excel Discussion (Misc queries) | |||
| Regular expressions in VB | Excel Discussion (Misc queries) | |||
| excel asp and expressions web | Excel Discussion (Misc queries) | |||
| Regular Expressions & Middle Name | Excel Worksheet Functions | |||
| Regular expressions in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
