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?