asterisk in formulas
 

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?

asterisk in formulas
 

replace :
G41="WBF/06/0MD*"
with
G41="WBF/06/0MD"&"*"



"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?

asterisk in formulas
 

=IF(AND(F41=1,LEFT(G41,10)="WBF/06/0MD"),K41,0)

HTH
Kostis Vezerides

asterisk in formulas
 

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

asterisk in formulas
 

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

--
Festina Lente


"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?