Ask Your Question
0

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

asked 2016-08-23 12:52:27 +0100

mdg gravatar image

updated 2016-08-23 13:52:55 +0100

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:

Fragment of sheet

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: https://www.dropbox.com/s/n2wljsesacp...

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-08-23 14:12:52 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

Thanks señor Riosv, that works perfectly.

mdg gravatar imagemdg ( 2016-08-23 14:28:33 +0100 )edit
0

answered 2016-08-23 14:04:58 +0100

pierre-yves samyn gravatar image

updated 2016-08-23 14:06:10 +0100

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

edit flag offensive delete link more

Comments

Thanks Pierre, that works perfectly.

mdg gravatar imagemdg ( 2016-08-23 14:29:18 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-23 12:52:27 +0100

Seen: 438 times

Last updated: Aug 23 '16