You could add the core words in and try it like this in E2, then:
=
--(SUMPRODUCT(--(ISNUMBER(SEARCH({"broke";"crack";"spoil";"miss";" peel";"ps2"},B2:D2))))0)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"FormulaQuestioner" wrote:
Here are some of the ones that I currently use

Monitor Missing, Monitor Broken, USB Keyboard Damaged, Has PS2 Keyboard,
Phone Broken, Wires peeled