Subject: Re: Excel function From: Brian FG Katz <brian.katz@xxxxxxxx> Date: Wed, 27 Jun 2012 10:59:57 +0200 List-Archive:<http://lists.mcgill.ca/scripts/wa.exe?LIST=AUDITORY>This is a multipart message in MIME format. ------=_NextPart_000_0060_01CD5453.FDB50490 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I suggest you learn to use the rather basic IF/THEN. =20 -- Brian FG Katz, Ph.D Audio & Acoustique LIMSI-CNRS BP 133 F91403 Orsay France tel. (+33) 01 69 85 81 55 fax. (+33) 01.69.85.80.88 e-mail <mailto:Brian.Katz@xxxxxxxx> Brian.Katz@xxxxxxxx < <mailto:Brian.Katz@xxxxxxxx> mailto:Brian.Katz@xxxxxxxx> web_theme: <http://www.limsi.fr/Scientifique/aa/thmsonesp/> http://www.limsi.fr/Scientifique/aa/thmsonesp/ web_group: <http://www.limsi.fr/Scientifique/aa/> http://www.limsi.fr/Scientifique/aa/ =20 =20 =20 De : AUDITORY - Research in Auditory Perception [mailto:AUDITORY@xxxxxxxx De la part de Vinay Envoy=E9 : mercredi 27 juin 2012 10:40 =C0 : AUDITORY@xxxxxxxx Objet : [AUDITORY] Excel function =20 =20 Dear list, =20 I need your suggestions regarding establishing an Excel function for the following type: =20 I have single digit numbers entered in three columns, and I have many = such rows in this pattern.=20 =20 I need to know the Excel function which can sort the numbers as follows: =20 1. If one number in any column is not a zero and the other two numbers = are zero - the excel has to assign 'A' for such a pattern=20 2. If two numbers are not zeroes and the third number is a zero - the = excel has to assign 'B' for such a pattern 3. All three numbers are not zeroes - the excel has to assign 'C' for = such a pattern. =20 Any suggestions? =20 =20 Regards, Vinay =20 =20 ------=_NextPart_000_0060_01CD5453.FDB50490 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta name=3DGenerator = content=3D"Microsoft Word 14 (filtered medium)"><style><!-- /* Font Definitions */ @xxxxxxxx {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @xxxxxxxx {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-family:"Calibri","sans-serif";} @xxxxxxxx WordSection1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue = vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>I suggest you learn to use the rather basic = IF/THEN.<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >--<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >Brian FG Katz, Ph.D<o:p></o:p></span></p><p class=3DMsoNormal><span = lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >Audio & Acoustique<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >LIMSI-CNRS<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >BP 133<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >F91403 Orsay<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >France<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >tel. (+33) 01 69 85 81 55<o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >fax. (+33) 01.69.85.80.88<o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >e-mail </span><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><a href=3D"mailto:Brian.Katz@xxxxxxxx"><span = lang=3DEN-US>Brian.Katz@xxxxxxxx</span></a></span><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= > <</span><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><a href=3D"mailto:Brian.Katz@xxxxxxxx"><span = lang=3DEN-US>mailto:Brian.Katz@xxxxxxxx</span></a></span><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >web_theme: </span><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><a href=3D"http://www.limsi.fr/Scientifique/aa/thmsonesp/"><span = lang=3DEN-US>http://www.limsi.fr/Scientifique/aa/thmsonesp/</span></a></s= pan><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= >web_group: </span><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><a href=3D"http://www.limsi.fr/Scientifique/aa/"><span = lang=3DEN-US>http://www.limsi.fr/Scientifique/aa/</span></a></span><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'= ><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><b><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De :</s= pan></b><span lang=3DFR = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> AUDITORY - = Research in Auditory Perception [mailto:AUDITORY@xxxxxxxx <b>De = la part de</b> Vinay<br><b>Envoy=E9 :</b> mercredi 27 juin 2012 = 10:40<br><b>=C0 :</b> = AUDITORY@xxxxxxxx<br><b>Objet :</b> [AUDITORY] Excel = function<o:p></o:p></span></p><p = class=3DMsoNormal><o:p> </o:p></p><div><p = class=3DMsoNormal><o:p> </o:p></p></div><p class=3DMsoNormal>Dear = list,<o:p></o:p></p><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p class=3DMsoNormal>I = need your suggestions regarding establishing an Excel function for the = following type:<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p class=3DMsoNormal>I = have single digit numbers entered in three columns, and I have many such = rows in this pattern. <o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p class=3DMsoNormal>I = need to know the Excel function which can sort the numbers as = follows:<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>1. If one number in any column is not a zero and the = other two numbers are zero - the excel has to assign 'A' for such a = pattern <o:p></o:p></p></div><div><p class=3DMsoNormal>2. If two = numbers are not zeroes and the third number is a zero - the excel = has to assign 'B' for such a pattern<o:p></o:p></p></div><div><p = class=3DMsoNormal>3. All three numbers are not zeroes - the excel = has to assign 'C' for such a pattern.<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>Any suggestions?<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>Regards,<o:p></o:p></p></div><div><p = class=3DMsoNormal>Vinay<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal><br clear=3Dall><o:p></o:p></p><div><p = class=3DMsoNormal><o:p> </o:p></p></div></div></div></body></html> ------=_NextPart_000_0060_01CD5453.FDB50490--