Getting different result According to contents of columns

[dpra]

<colgroup><col width="64" span="4" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody></tbody>

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.

NY1	NY2	NY3	NY4	Result
1	5	9	37	A
8	1	7	11	A
9	1	8	9	A
2	18	0	10	B
2	19	17	15	B
1	2	17	12	C
5	2	1	7	C
3	10	18	8	D
1	2	3	18	E
4	3	1	2	E

<tbody>
</tbody>

 

[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