H

#### Hicksey

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