Hi
try
=IF(AND(A1=3,A2=2,A3=1,A4=0),3,"")
in your target cell

--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im Newsbeitrag
...
I need a formula that for the following:

If Cell 104 = 3 AND CELL 105 =2 AND Cell 106 =1 AND Cell 107 =0,
Cell 108 =3