How to check if a column contains a certain word?

Hi,

I have a transaction list of invoices and column N contains their status (processed/unprocessed/query). How can I create a formula to check whether any of the invoices are still in query, i.e. it looks in column N for the word 'query' and returns 'yes' if any are and 'no' if any aren't.

Thanks,

Snook