Hi Stu,

Am Thu, 15 Mar 2012 08:19:38 +0100 schrieb Claus Busch:

=IF(ISNUMBER(SEARCH("AF",B2))+ISNUMBER(SEARCH("X", D2))<2,"","true "&(IF(COUNT(SEARCH({"SP";"HA";"PA"},C2))0,CHOOSE( COUNT(SEARCH({"SP";"HA";"PA"},C2)),"ONE","TWO","TH REE"),"")))

it is a typo in the formula above. Try:
=IF(ISNUMBER(SEARCH("AF",B2))+ISNUMBER(SEARCH("X", D2))<2,"","true "&(IF(COUNT(SEARCH({"SP","HA","PA"},C2))0,CHOOSE( COUNT(SEARCH({"SP","HA","PA"},C2)),"ONE","TWO","TH REE"),"")))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2