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