Excel - How do I conditionally insert text into a cell on Excel 2007?

Asked By RobertTF on 07-Aug-08 03:20 PM
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




Peo Sjoblom replied on 07-Aug-08 03:58 PM
I assume you meant C1 or else you would need an event macro

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

since you did not mention what you want if it is not "No" I made it blank

--


Regards,


Peo Sjoblom