Add text cell C1 if certain text in B1
 

Hello,

My spreadsheet is set up like this.

B1
C1
Cell phone is 50%. Home is 50 mi. away. 80% was rate at this time.

I want to automatically add the text "80% was the rate at this time" in cell
C1 only if there is text in cell B1 that says "cell phone".

Can anyone help?

Thanks

Add text cell C1 if certain text in B1
 

Try either in C1:

=IF(COUNTIF(B1,"*cell phone*"),"80% was the rate at this time","")
=IF(ISNUMBER(SEARCH("*cell phone*",B1)),"80% was the rate at this time","")
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Studebaker" wrote in message
...
Hello,

My spreadsheet is set up like this.

B1
C1
Cell phone is 50%. Home is 50 mi. away. 80% was rate at this time.

I want to automatically add the text "80% was the rate at this time" in cell
C1 only if there is text in cell B1 that says "cell phone".

Can anyone help?

Thanks

Add text cell C1 if certain text in B1
 

Thank you! I only used the 1st formula and it worked.


"RagDyeR" wrote:

Try either in C1:

=IF(COUNTIF(B1,"*cell phone*"),"80% was the rate at this time","")
=IF(ISNUMBER(SEARCH("*cell phone*",B1)),"80% was the rate at this time","")
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Studebaker" wrote in message
...
Hello,

My spreadsheet is set up like this.

B1
C1
Cell phone is 50%. Home is 50 mi. away. 80% was rate at this time.

I want to automatically add the text "80% was the rate at this time" in cell
C1 only if there is text in cell B1 that says "cell phone".

Can anyone help?

Thanks

Add text cell C1 if certain text in B1
 

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Studebaker" wrote in message
...
Thank you! I only used the 1st formula and it worked.


"RagDyeR" wrote:

Try either in C1:

=IF(COUNTIF(B1,"*cell phone*"),"80% was the rate at this time","")
=IF(ISNUMBER(SEARCH("*cell phone*",B1)),"80% was the rate at this
time","")
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Studebaker" wrote in message
...
Hello,

My spreadsheet is set up like this.

B1
C1
Cell phone is 50%. Home is 50 mi. away. 80% was rate at this
time.

I want to automatically add the text "80% was the rate at this time" in
cell
C1 only if there is text in cell B1 that says "cell phone".

Can anyone help?

Thanks