Add text cell C1 if certain text in B1

[Studebaker]

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

 

[RagDyeR]

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!
=====================================================


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

 

[Studebaker]

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

 

[RagDyer]

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