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!

Hi

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

Cheers
JulieD


"soxn4n04" wrote in message
...
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!