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

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?


Regards,
Vinay