More questions...

[soxn4n04]

Please help me to determine the score of the following:

If Cell 13=1, score = 3 OR
If Cell 13= 5 AND Cell 14 = 1, score = 2 OR
If Cell 15 = 5 or DK, score = 0 OR
All others, score = 1

Thanks!

 

[JulieD]

Hi

=IF(A13=1,3,IF(AND(A13=5,A14=1),2,IF(OR(A15=5,A15="DK"),0,1)))

Cheers
JulieD