Re: [libreoffice-users] IF statement question

Hi Gordon,

You didn't specify what the value of col. C shou;d be if both A and B are blank.

Using  =IF(ISBLANK(A2);"Y";IF(A2=B2;"";"X"))   will put "Y" in there for above case.

Success,

Rob.

Op 31 jul. 2014, om 12:03 heeft Gordon Burgess-Parker het volgende geschreven:

> Sorry that's all mucked up.
> I'll post a link to this.
> https://www.wuala.com/gordonbp/Public/
>
>
> On 31/07/14 10:53, Gordon Burgess-Parker wrote:
> > Hi Gurus!
> > I'm getting all in a twist over nested IF statements.
> > Here's what I want to do.
> > I have three columns A, B and C.
> > There is a list in Columns A and B and a result in C, but with gaps in each list as under:
> >
> >
> > A
> >    B
> >    C
> > Fred
> >    Fred
> >
> > George
> >
> >    X
> >
> >    James
> >    Y
> > Jones
> >    Jones
> >
> > Smith
> >    Smith
> >
> >
> >
> > What I'm looking for is a nested IF statement in Column C that says "if A=B do blank, otherwise 
> > do "X" OR, if A="" then do "Y"
> > I can do the first condition, but I'm running into trouble combining the second in one statement.
> >
> > Hope that's clear!
> >
> > Cheers
> > Gordon
>
>
> -- 
> 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


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