Re: [libreoffice-users] help with find

What about
=ISERR(SEARCH("Nationwide";B1))+1


> Op 19 jul. 2024, om 23:30 heeft James <bjlockie@lockie.ca> het volgende geschreven:
>
> 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


-- 
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