=IF(OR(ISNUMBER(FIND("WALGREENS",E5)),ISNUMBER(FIN D("CVS",E5))),60,
IF(ISNUMBER(FIND("TARGET",E5)),120,""))

--
HTH

Bob Phillips

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

"Dan Hale" wrote in message
...
Ok that's great to know, but the problem is that "WALGREENS" or "CVS" or
"Target" are not the only text in the cell so I need a formula that would
work like yours but checks if the cell contains those words?


"Rookie 1st class" <Rookie1stClass@SpamThis wrote in message
...
In F6 paste
=if(E6="WALGREENS",60,if(E6="CVS",60,if(E6="TARGET ",120,"")))' you can
gang
up to 6 if statements together.
HTH Lou

"Dan Hale" wrote:

Thanks
Now let's add something else
Here is the formula real
=IF(OR(ISNUMBER(FIND("WALGREENS",E5)),ISNUMBER(FIN D("CVS",A1))),60,"")
Now what I need to do is if the cell contains "WALGREENS" OR "CVS"
return
60
like above, but if it contains "TARGET" return 120 else blank

Thanks

"Bob Phillips" wrote in message
...
=IF(OR(ISNUMBER(FIND("Target",A1)),ISNUMBER(FIND(" CVS",A1))),1,"")

--
HTH

Bob Phillips

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

"Dan Hale" wrote in message
...
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