Error #VALUE! when using IF operation

Asked

Viewed 42 times

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 don’t understand why I should appear FALSE error #VALUE!.

According to link can be a syntax error or lack of use of "error-Handling formulas".

It is possible to appear FALSE without using these error formulas?

inserir a descrição da imagem aqui

excel

1 answer

1


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

That uses the function SEERRO() OR IFERROR() to return the false value. This is because by checking what the search function returns on the line where the error occurs, it returns the error #VALOR!. As in the demonstration below.

Demo

Therefore, to circumvent this error, the SEERRO function is used.

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.