Subject: Re: Excel function From: Vinay <shrivinyasa@xxxxxxxx> Date: Wed, 27 Jun 2012 11:31:14 +0200 List-Archive:<http://lists.mcgill.ca/scripts/wa.exe?LIST=AUDITORY>--f46d042c6c4d92906804c370e112 Content-Type: text/plain; charset=ISO-8859-1 Dear list, Thanks for your responses. I have got the solution. Regards, Vinay On Wed, Jun 27, 2012 at 10:39 AM, Vinay <shrivinyasa@xxxxxxxx> wrote: > > 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 > > > > --f46d042c6c4d92906804c370e112 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <div><br></div>Dear list,<div><br></div><div>Thanks for your responses.</di= v><div><br></div><div>I have got the solution.</div><div><br></div><div><br= ></div><div><br></div><div>Regards,</div><div>Vinay</div><div><br></div> <div><br></div><div><br></div><div><br><br><div class=3D"gmail_quote">On We= d, Jun 27, 2012 at 10:39 AM, Vinay <span dir=3D"ltr"><<a href=3D"mailto:= shrivinyasa@xxxxxxxx" target=3D"_blank">shrivinyasa@xxxxxxxx</a>></spa= n> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"><div><br></div>Dear list,<div><br></div><div= >I need your suggestions regarding establishing an Excel function for the f= ollowing type:</div> <div><br></div><div>I have single digit numbers entered in three columns, a= nd I have many 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> </blockquote></div><br></div> --f46d042c6c4d92906804c370e112--