How can put a text string in a cell (message) based on tha calculation in
another 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

Ron,
Are you trying to do this with VBA? If so,
For example, cell C4 will show result, if C3=C2

Range("C4").Select
ActiveCell.FormulaR1C1 = "=IF(R[-1]C=R[-2]C,""good"",""bad"")"
The RC lets you select the offset of the rows and columns, this says if
cell one row above = cell two rows above, then return "good", else
"bad"

Let me know if this is what you're looking for

Andrew J Armstrong

To do this
Ron Rosenfeld wrote:
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