=IF(AND(A1="Black",OR(B1="Ford",B1="Toyota")).True ,FAlse)

--
HTH

-------

Bob Phillips
"GLS" wrote in message
...
Hi

I have two columns of car data, 'A' is colour and 'B' is make. I want to
set up a formula where if 'A1' is black and 'B1' is either Ford or Toyota
it
will show 'True' in cell 'C1'.

Many thanks
--
GLS