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: [email protected]
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
