Scoring multiple cells

soxn4n04 · Dec 7, 2004

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 · Dec 7, 2004

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