Re: [libreoffice-users] Calc: wildcard use to intercept a string

At 09:08 14/11/2016 -0700, Fonly Bonly wrote:
> how can I match the string XYZ in a cell?
> Example: count.if(interval; XYZ )
>
> string ---> result
> XZ 0
> GXYZ 1
> GXP 0
> AABXYZC 1

Try:
=NOT(ISERROR(FIND("XYZ";A1)))
This will give TRUE if XYZ is found and FALSE if not. If you format 
those as numbers, they will appear as 1 and 0 respectively.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted