Hi Paul
Thank you for responding.

i dont understand your margin thing say the score in a game is 10-3 the
actual margin is 7 what is your +10-10 on that
17 to -3

I dont actually have to understand the scoring. I only get to fill in the
numbers. Luckey me!
Regards
Paul

"paul" wrote in message
...
i dont understand your margin thing say the score in a game is 10-3 the
actual margin is 7 what is your +10-10 on that
ps I hope you got the right score in the All Blacks vs The Wallabies last
night,looked a bit dodgy at half time.
--
paul

remove nospam for email addy!



"Hicksey" wrote:

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