=if(countif(A1,"*bird*"),"Yes","No")

If you want it to be case sensitive ("TWEETY bird" would result in No), then
use Toppers' suggestion.

--
Regards,
Tom Ogilvy

"Geezer" wrote in message
om...
Greetings all you XLS Masters


IF cell A1 equals TWEETY BIRD
This is what I want to do in cell B1
=if(a1 CONTAINS "BIRD","YES","NO", false)

It must be simple - unlike the HELP system on Excel

Care to help?
Thank You
CB