View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How can put a text string in a cell

On Thu, 9 Nov 2006 16:38:02 -0800, Dennis C BroadWare <Dennis C
wrote:

How can put a text string in a cell (message) based on tha calculation in
another cell?


In message cell, enter a formula of the type:

=IF(another_cell = good_result,"another_cell showed good result", "")




--ron