Hi all

I've been trying to solve this one for a week and am just getting nowhere,
any help would be greatly appreciated.

I have a list of shops in column A and a list of total sales figures in
column B, Some of the shops in Column A are chains and so have multiple
entries (think WH Smiths, Borders etc...). I'm trying to write a formula that
will check to see if the Characters WHS are in column A and see if the figure
in Column B is greater than 15000, and if so enter "Sales OK" otherwise enter
"NON Chain". The best I could come up with is
=if(and(find("WHS*",a2)b2>15000,"Sales OK","NON Chain")) but it doesn't work.
Help!!!!!