Error #VALUE! when using IF operation

1

I have this table in Excel and in column E I have the following expression: =IF(AND(SEARCH("qwe*";B:B);SEARCH("qaz";C:C));TRUE;FALSE)

I do not understand why it should appear FALSE to see the #VALUE! error.

-b143-c08a24dbe812? ui = en-US & rs = en-US & ad = US "> link may be a syntax error or non-use of" error-handling formulas ".

Is it possible to appear FALSE without using these error formulas?

    
asked by anonymous 17.05.2018 / 15:13

1 answer

1

You can solve this with: =SEERRO(SE(E(LOCALIZAR("qwe*";B:B);LOCALIZAR("qaz";C:C));VERDADEIRO;FALSO);FALSO)

You use the SEERRO() OR IFERROR() function to return the false value. This occurs because when checking what the search function returns on the line where the error occurs, it returns the error #VALOR! . As in the demo below.

Therefore, to work around this error, the SEERRO function is used.

    
17.05.2018 / 15:48