Thread
:
Complex AND OR Formula
View Single Post
#
6
June 5th, 2010, 11:18 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett[_3_]
external usenet poster
Posts: 3
Complex AND OR Formula
I did!!!
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"David Biddulph" groups [at] biddulph.org.uk wrote in message
...
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
Don Guillett[_3_]
View Public Profile
View message headers
Find all posts by Don Guillett[_3_]
Find all threads started by Don Guillett[_3_]