Should be a easy How do I
Well actually you can have 8, 7 nested.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Michael M" wrote in message
...
Hi
You can actually use 7 IF statements not 6.........but any more than that
would suggest you use a VLOOKUP table
HTH
Michael M
"Rookie 1st class" wrote:
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
|