if the cell contains multiple text criteria then return the corresponding text criteria

[greevek]

Hi

Please can someone help, I have a formula that looks at a cell and returns a 1 if it matches the criteria and doesn't contain another specific word. Here is the formula:

=AND(COUNT(SEARCH({"Apple","Orange","Peach"},$A2))>0,COUNT(SEARCH({"Pears"},$A2))=0)

The problem I have is I want it to only return the result if all the criteria are met, i.e. the cell contains Apple, Orange, and Peach. At the minute it returns a 1 if any one of the 3 words is showing in that box, it does of course return 0 if Pears is included which is a result! Can anyone help me with my formula so it will return the result I am looking for? Also, not sure if this matters, but the words won't always be entered in the cell in the same order, it is randomly added from a quiz result.
(I Apologise if I haven't explained what I am looking for either.)

 

[Phuoc]

=AND(COUNT(SEARCH({"Apple","Orange","Peach"},$A2))=3,COUNT(SEARCH({"Pears"},$A2))=0)

 

[etaf]

Edit - Better formula added as i was typing

 

[greevek]

=AND(COUNT(SEARCH({"Apple","Orange","Peach"},$A2))=3,COUNT(SEARCH({"Pears"},$A2))=0)

Thank you so much, this was one of those formulas that I could not get my brain to figure out what I was missing. Works perfectly and I have already adapted it for other answers that have 2 or 4 answers in the cell. I knew I should have just come straight to the hive mind instead of struggling for 4 days!