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