Thread: Complex AND OR Formula
View Single Post
  #2  
Old June 5th, 2010, 10:32 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
  
Posts: 607
Default Complex AND OR Formula
=IF(AND(RIGHT(E2,2)="1bx",j2=11),1,j2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Colin Hayes" wrote in message
...

HI

I need to express something in a formula , and am having trouble with it.

I need to say this :

IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2 =11 THEN PUT 1 ,
OTHERWISE PUT J2

Can someone assist with some code to make this happen , please?

Grateful for any help. Sorry for double post.



Best Wishes