Re: [libreoffice-users] If Cell Contains String True

Ah, thank you both again....hopefully this is the last time ;)

Best,
Joel


On Thu, Feb 21, 2013 at 12:13 PM, Alan Boba <aboba0@gmail.com> wrote:

> On Thu, Feb 21, 2013 at 1:43 PM, Joel Madero <jmadero.dev@gmail.com>
> wrote:
>
> > What I have:
> >
> > A|B
> > comment|regression check
> > regression|
> > regression,BSA,i10n|
> > BLANK|
> > BLANK|
> > regression|
> > regression,bibisected|
> > BSA|
> > BSA|
> > cleanup0407|
> >
> > If that's not clear those are A1:B10, where | splits A and B columns. B
> > column is empty other than B1 which has header "regression check"
> >
> > I need a formula which will be true if the word "regression" is in A at
> all
> > (so in the above example A2, A3,A5,A6 would all be true).
>
> If I'm understanding what you want I think this function will give the
> results you're looking for
>  =NOT(ISERROR( SEARCH("regression",A2)))
>
> SEARCH() is case insensitive so finds the word no matter the capitalization
> ISERROR() accounts for empty cells and cells with numbers that cause
> SEARCH() to fail
> NOT() causes the result to be TRUE when ISERROR() returns FALSE because the
> nested SEARCH() is TRUE
>
> --
> For unsubscribe instructions e-mail to: users+help@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


-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero.dev@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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