Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Should be a easy How do I

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


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default Should be a easy How do I

=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




  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Should be a easy How do I

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






  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 152
Default Should be a easy How do I

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







  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 118
Default Should be a easy How do I

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









  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 299
Default Should be a easy How do I

Actually you can trick Excel by dumbing down the formula

=IF(E6="A",60,""&IF(E6="B",60,"")&and so on

only limitation is the length of the formula, having said that I wouldn't
recommend it since the formula would be very ugly

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"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









  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Should be a easy How do I

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









  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 118
Default Should be a easy How do I

I still think you need a VLOOKUP table

Go to somewhere where you have some space, say G1.
In column G list all the stores
In column H list their values.

Go back to where you want the formula and use:
=VLOOKUP(E6,G1:H100,2, FALSE)

HTH
Michael M

"Dan Hale" wrote:

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










  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default 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









  #10   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default Should be a easy How do I

=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











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy question? Page numbers ATC Excel Discussion (Misc queries) 1 February 1st 06 05:27 AM
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. PriceTrim Excel Discussion (Misc queries) 3 July 5th 05 05:27 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM
Easy formula Question Excel formula fix Excel Worksheet Functions 3 March 29th 05 02:04 AM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 10:17 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"