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