Find function returns #VALUE! if the string is not found?

[mdg]

LibreOffice calc: Version: 5.1.4.2 - Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a - Win7

Why does the find function return #VALUE! if the FindText is not found?

I have:

This “Fragment of sheet” is supposed to be a clickable link but peview doesn’t show it. If it doesn’t show up here is the link:

I want to use FIND(“e”,A1)>=0 as the conditional part in an IF function which works well if the FindText is found but if the FindText is not found then the #VALUE spoils the result.

Mike

[PYS]

Hi

You can use IFERROR: Returns the value if the cell does not contains an error value, or the alternative value if it does.

So =IFERROR(FIND("e";A1);0) or =IFERROR(FIND("e";A1)>=0;0)

note: my interface is french so I use ; as separator

Regards

[mdg]

Thanks Pierre, that works perfectly.

[mariosv]

It’s how the function works, you can use IFERROR(FIND("e",A1);0)>=0 or ISERROR(FIND("e",A1))=0 to avoid the issue.

[mdg]

Thanks señor Riosv, that works perfectly.