[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel function

I suggest you learn to use the rather basic IF/THEN.



Brian FG Katz, Ph.D

Audio & Acoustique


BP 133

F91403 Orsay


tel. (+33) 01 69 85 81 55

fax. (+33)

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
Envoyé : mercredi 27 juin 2012 10:40
À : AUDITORY@xxxxxxxxxxxxxxx
Objet : [AUDITORY] Excel function



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?