Hi Andrew:

If InStr(cellvalue,x)0 Then
MSGBOX("Y")
else
MSGBOX("N")
endif


--
Gary's Student
gsnu200705


"Andrew" wrote:

Is there a way of writing the following?

=if ( cell 'contains' x , then write "y" , else write "n" )
The cell contains text.

Suggestions appreciated, thanks.