Thread
:
Complex AND OR Formula
View Single Post
#
3
June 5th, 2010, 10:42 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
Posts: 8,714
Complex AND OR Formula
I assume that you intended =IF(AND(RIGHT(E2,2)="bx",j2=11),1,j2) ?
"bx", not "1bx", as you've got 2, not 3, as the second parameter of the
right function?
--
David Biddulph
"Don Guillett" wrote in message
...
=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
David Biddulph
View Public Profile
View message headers
Find all posts by David Biddulph
Find all threads started by David Biddulph