Gordon, Working the other way around blanks C in case both A & B are blank.
=IF(A2=B2;"";IF(ISBLANK(A2);"Y";"X")) Rob. Op 31 jul. 2014, om 12:42 heeft Rob Jasper het volgende geschreven: > > 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 > -- 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
