Ask Your Question
0

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

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

mdg gravatar image

updated 2020-09-10 20:49:26 +0100

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 20:50:18.577497

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

Question Tools

1 follower

Stats

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

Seen: 697 times

Last updated: Aug 23 '16