Hi all,

I need a formula to count if a cell contains the words 'best' and 'crm' in any order. For example:

Screen Shot 2017-04-07 at 12.46.54.png

What formula would I use in B1 - B5 to get a true value for cells A1 to A4, but a false value for A5?

Thanks!