Multiple IFS For Fantasy League

My rules are as follows.

Correct Position = 3
One Either Side = 1
If Position Guess > 5 Wrong = -1

Struggling to make a multiple IF For the related boxes

(I have tried attaching said file. But it wont let me.)


So basically I have sorted the IF statement for first two rules.
=IF(B6=Z6,3,IF(B6=Z7,1,IF(B6=Z5,1,0)))



Using that.

But I basically want to add an IF, which when the text (value) isn't equal to any boxes within a range of 5 up and 5 down In the table. The points scored = -1
Any help would be appreciated.

Thanks









SOLVED