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