I have the task of manually filling in the results from rugby matches in a
spread sheet for a works guessing game. Please could someone help with a
formula to do the following and show the final score in column L2. I just
would not know where to start. Thank you

Points system
Home win 1 point. Away win 2 points. Correct winning/losing score 3
points. Draw 5 points. Correct game score 8 points. Correct score draw 10
points. Correct margin 1 point.( the tolerence of +10 to -10 of the actual
score.)

Only the highest appropriate points to be allocated (e.g you cannot be
awarded 3 points for correct winning score plus 1 point for home win). The
only exception is when a bonus point for correct margin is awarded..( the
tolerence of +10 to -10 of the actual score.)

A2 Home Team
B2 Home score
C2 Away score
D2 Away Team
E2 Points
F2 Margin
G2 = F2+10
H2 = F2-10
I2 Home Team Guess
J2 Away Team Guess
K2 Margin
L2 Points