Re: [libreoffice-users] IF statement question

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