Complex AND OR Formula
In article , Don Guillett
writes
=IF(AND(RIGHT(E2,2)="1bx",j2=11),1,j2)
Hi Don
OK Thanks for that.
I can't quite get it to work though , for what I have in mind.
I found that this works for a single search parameter :
=IF(AND(COUNTIF(E2,"*1bx*"),COUNTIF(J2,"11")),1,J2 )
but of course it only looks for "*1bx*". I need in incorporate an OR
expression to also search for "*2bx*" , "*3bx*" and "*4bx*" in the same
formula.
Any ideas how to work these other values in?
Thanks for your help.
Best Wishes
|