Subject: Excel function From: Vinay <shrivinyasa@xxxxxxxx> Date: Wed, 27 Jun 2012 10:39:48 +0200 List-Archive:<http://lists.mcgill.ca/scripts/wa.exe?LIST=AUDITORY>--f46d04016dcfa0b12904c370294e Content-Type: text/plain; charset=ISO-8859-1 Dear list, I need your suggestions regarding establishing an Excel function for the following type: I have single digit numbers entered in three columns, and I have many such rows in this pattern. I need to know the Excel function which can sort the numbers as follows: 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 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. Any suggestions? Regards, Vinay --f46d04016dcfa0b12904c370294e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <div><br></div>Dear list,<div><br></div><div>I need your suggestions regard= ing establishing an Excel function for the following type:</div><div><br></= div><div>I have single digit numbers entered in three columns, and I have m= any such rows in this pattern.=A0</div> <div><br></div><div>I need to know the Excel function which can sort the nu= mbers as follows:</div><div><br></div><div>1. If one number in any column i= s not a zero and the other two numbers are zero - the excel has to assign &= #39;A' for such a pattern=A0</div> <div>2. If two numbers are not zeroes and the third number is a zero -=A0th= e excel has to assign 'B' for such a pattern</div><div>3. All three= numbers are not zeroes -=A0 the excel has to assign 'C' for such a pattern.</div><div><br></div= ><div>Any suggestions?</div><div><br></div><div><br></div><div>Regards,</di= v><div>Vinay</div><div><br></div><div><br clear=3D"all"><div><br></div> </div> --f46d04016dcfa0b12904c370294e--