One way:

=IF(LEFT(Q11,3)="abc","good","bad")

Regards

Trevor


"jstocka" wrote in message
...
What is the proper application of a wild card in an "if
then" statement. I am trying to select by the first three
letters of a field. using the asterik after the three
letters does not work all my resources do not show any
examples. Any ideas??
thanks