I assume you meant C1 or else you would need an event macro

=IF(B1="No","Explain","")

since you didn't mention what you want if it is not "No" I made it blank

--


Regards,


Peo Sjoblom

"RobertTFB" wrote in message
...
I am using Excel 2007. I am trying to insert text into a cell based on the
value of the cell next to it. Example If NO is typed into cell B1, I want
to
insert EXPLAIN in cell B1