Scoring multiple cells

[Guest]

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

 

[Frank Kabel]

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