setting text in 1 cell from values in other

[bp]

hello,
I think this is pretty easy. but cannot get it.
I have 2 cells. lets say A1 and B1. in B1 I have text. I want to set the
value of A1 to 100, if B1 contains the values "ABC" or "DEF". B1 can
contain a lot of text. not exact values. can anyoe help me out with this?

thanks.

 

[Bob Phillips]

One way

=IF(SUMPRODUCT(COUNTIF(B1,{"*ABC*","*DEF*"}))>0,100,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[bp]

thanks. it does work

One way

=IF(SUMPRODUCT(COUNTIF(B1,{"*ABC*","*DEF*"}))>0,100,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)