Re: [libreoffice-users] help with find

I want to do something like this now:
=IF(FIND("Nationwide", B1)>0,1,2)
It works if "Nationwide" is found in B1 but I get #VALUE! if it is not 
found.
I'm guessing because the FIND is not returning a number?

On 2024-07-16 23:41, Brian Barker wrote:
> At 21:11 16/07/2024 -0400, James Lockie wrote:
> > B1 = Data Nationwide
> > B2 = =FIND("Nationwide", B1, 0)
> > I get #VALUE!
>
> Good! Your computer is working properly.
>
> You have asked FIND() to start looking at the zeroth character in the 
> text, which doesn't exist. The characters are the first, second, 
> third, and so on. Try:
> =FIND("Nationwide",B1,1)
> or just:
> =FIND("Nationwide",B1)
>
> I trust this helps.
>
> Brian Barker

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy