IF Statement Text Check

[rhmkrmi]

Hello:

I need to check if the value in cell A1 contains a cetarin text, I am using IF(A1="*test*","Y","N") but it does not seem to do the job.

What am I doing wrong?

Thanks

 

[jim may]

Excel 2012
	A	B	C	D
1	abctestdef			Y
Sheet1

Cell Formulas
Range	Formula
D1	=IF(FIND("test",A1)>0,"Y","N")

 

[My Aswer Is This]

Try [FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][FONT="Times New Roman"][FONT=Times New Roman][COLOR=#000000]=IF(ISNUMBER(SEARCH("Test",A1)),"Y", "N")[/COLOR][/FONT][/FONT]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/CO[/COLOR][/SIZE][/FONT]DE]