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