Isnumber, find, search, looking for formula

[kamulee6]

Hi, I having cell A with few texts let's put as (x y z) ; cell B will be either result 1 or 0. Now cell C, I wish to search cell A contains "y" and cell B is "0", then result cell C is "no".

 

[jtakw]

Hi,

Like this?

Excel 2010
	A	B	C
1	x y z	0	no
Sheet1

Cell Formulas
Range	Formula
C1	=IF(AND(ISNUMBER(SEARCH("y",A1)),B1=0),"no","")