Maybe this

=IF(OR(LEFT('Priced BOM'!$W$1,3)<"DLA",LEFT('Priced
BOM'!$W$1,3)<"GFM"),"Quote",'Priced BOM'!$W$1)

another way

=IF(OR(ISERR(FIND(,"DLA",'Priced BOM'!$W$1)),ISERR(FIND("GFM",'Priced
BOM'!$W$1))),"Quote",'Priced BOM'!$W$1)

which is case sensitive and will work if there are leading spaces etc
replace with SEARCH if not case sensitive

Regards,

Peo Sjoblom


"Joe Gieder" wrote in message
...
First, thank you for looking at his and your expert help and advice.

I have this Array entered formula in cell V1:
=IF('Priced BOM'!$W$1<(OR((LEFT('Priced BOM'!$W$1,3)="DLA"),(LEFT('Priced
BOM'!$W$1,3)="GFM"))),"Quote",'Priced BOM'!$W$1)

and it give the wrong result, it evaluates to True when it should be False
because W1 has the value "DLA".
I need for it to say "Quote" if cell W1 does not contain the text "DLA" or
"GFM" and state the value that is in W1 if it evaluates to False. Is there
a
way to use OR in the formula or can what I want to do just not be done?

Thank you in advance for your help
Joe