'IF' Formula help

[bdenson]

I have a EPL predictions game where players predict the final finishing positions in the league for each of the 20 teams.

The scoring works as follows...

5 points – Correct Place
3 points – 1 or 2 places out
-5 points – wrong by more than 5

I am trying to add a formula to work out the score for each player (for each team) which I will then do a SUM of to get the total score.

I tried to do this with an IF statement but couldn't get it to work.

Can anyone point me in the right direction?

Thanks

Barry

 

[popipipo]

=IF(A1=B1;5;(IF(ABS(B1-A1)<3;3;IF(ABS(A1-B1)>5;-5;""))))

Is this the right direction?