Getting different result According to contents of columns

[dpra]

[TABLE="width: 320"]
<colgroup><col width="64" span="4" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody></tbody>[/TABLE]
I am trying to get result in a column based on contents of previous 4 columns.
For example as per table below, if there is value 1 in either of first 4 columns of same row, I want to display A in column 5. As first 4 columns in row 2 to 4 contains 1, result is A.
If there is any 2 in first 4 columns, I want to display B.
If there are both 1 and 2 in any first 4 columns, I want to display C.
If there is 3 in any of first 4 columns, I want to display D.
And if all 1, 2 and 3 are in any of first 4 columns, I want to display E.

I would really appreciate if someone can help me putting some sort of conditional formula with what I want to achieve.


[TABLE="width: 207"]
<tbody>[TR]
[TD] NY1
[/TD]
[TD] NY2
[/TD]
[TD] NY3
[/TD]
[TD] NY4
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]37
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]11
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]1
[/TD]
[TD]8
[/TD]
[TD]9
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]18
[/TD]
[TD]0
[/TD]
[TD]10
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]19
[/TD]
[TD]17
[/TD]
[TD]15
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]17
[/TD]
[TD]12
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]7
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]10
[/TD]
[TD]18
[/TD]
[TD]8
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]18
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]E[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

If each number can appear only once:

=IF(SUM(COUNTIF(A2:D2,{1,2,3}))=3,"E",IF(SUM(COUNTIF(A2:D2,{1,2}))=2,"C",IF(COUNTIF(A2:D2,1),"A",IF(COUNTIF(A2:D2,2),"B",IF(COUNTIF(A2:D2,3),"D","")))))

 

[dpra]

If each number can appear only once:

=IF(SUM(COUNTIF(A2:D2,{1,2,3}))=3,"E",IF(SUM(COUNTIF(A2:D2,{1,2}))=2,"C",IF(COUNTIF(A2:D2,1),"A",IF(COUNTIF(A2:D2,2),"B",IF(COUNTIF(A2:D2,3),"D","")))))

Thank You very much Andrew. This solved my problem.

Thanks