|
I suggest you learn to use the rather basic IF/THEN. -- 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 Brian.Katz@xxxxxxxx <mailto:Brian.Katz@xxxxxxxx> web_theme: http://www.limsi.fr/Scientifique/aa/thmsonesp/ web_group: http://www.limsi.fr/Scientifique/aa/ De : AUDITORY - Research in Auditory Perception [mailto:AUDITORY@xxxxxxxxxxxxxxx] De la part de Vinay 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 |