I'm not sure what you're doing with that =or() portion, but you can use:

=isnumber(search("WBF/06/0MD",g41))
to check G41 for "wbf/06/0md".

=search() is not case sensitive.

Use =Find() if you want a case sensitive comparison.


Ahhh.

maybe...

=IF(AND(F41=1,isnumber("WBF/06/0MD",g41)),K41,0)

STF wrote:

I Have:
=IF(AND(F41=1,OR(G41="WBF/06/0MD-AU",G41="WBF/06/0MD-CH",G41="WBF/06/0MD-DE",G41="WBF/06/0MD-HTML",G41="WBF/06/0MD-OUT",G41="WBF/06/0MD-STORE",G41="WBF/06/0MD-OUT",G41="WBF/06/0MD-WEB",G41="WBF/06/0MD-WEBI")),K41,0)
I'd like to have:
=IF(AND(F41=1,OR(G41="WBF/06/0MD*",K41,0)
Why is the aterisk not working in the formula?

--

Dave Peterson