if(or (search...issue

[bluepenink]

=IF(OR((SEARCH("AE",C7&"AE"),>LEN(C7)),((SEARCH("Rep",C7&"Rep"),>LEN(C7)))),0,1)
Having problem with the above formula

basically, im saying

If cell contains AE or Rep, then show 0, 1

can someone pls help.thx u

 

[Matty]

Maybe:

=IF(OR(ISNUMBER(SEARCH({"AE","Rep"},A2))),0,1)

Matty

 

[servcoor]

Not sure I fully understand what you're trying to accomplish or why you're using SEARCH and LEN but you might try this: =IF(A1="ae",0,IF(A1="rep",0,1)). Returns 0 if cell A1 equals either AE or Rep, 1 if neither.