ExcelBanter - Scoring multiple cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Scoring multiple cells (https://www.excelbanter.com/excel-worksheet-functions/7582-scoring-multiple-cells.html)

soxn4n04

Scoring multiple cells

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

--
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

All times are GMT +1. The time now is 11:30 PM.