I suggest you learn to use the rather basic IF/THEN.
Brian FG Katz, Ph.D
Audio & Acoustique
tel. (+33) 01 69 85 81 55
fax. (+33) 01.69.85.80.88
De : AUDITORY - Research in Auditory Perception [mailto:AUDITORY@xxxxxxxxxxxxxxx] De la part de Vinay
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.