Formula for returning a yes or no answer

[Bonny]

Can anyone tell me what the formula is for returning a answer of yes or no, i.e.
you have a list of cars and you want to mark all the ford cars with a yes and all other cars as no.

 

[Paul B]

bonny, something like this, with list in column A put this in A1 and copy
down

=IF(A1="ford","yes","no")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Can anyone tell me what the formula is for returning a answer of yes or no, i.e.
you have a list of cars and you want to mark all the ford cars with a yes

and all other cars as no.