Should be easy how to

[Dan Hale]

I have a spreadsheet that I put Store names and addresses in the same cell
(say E5), I need a formula so that if E5 contains "Target" or "CVS" that in
cell F6 it will return a number. Should be easy can someone please show me
the formula?

Thanks

 

[Bob Phillips]

See response in .newusers

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)