This doesn't give the 3 points for correct predicttion of a draw?
--
David Biddulph

"Toppers" wrote in message
...
=((A2B2)*(C2D2))*3+(A2=C2)+(B2=D2)

A2=Actual Home
B2=Actual way

C2=Predicted Home
D2=Predicted Away

HTH

"JockW" wrote:

I'm unsure if this is do-able, but I know some of you will relish the
challenge....
I'm creating a spreadsheet showing points gained from predicting soccer
scores.
For the correct result (ie home win, away win or draw) - 3 points,
For getting home team score correct - 1 point,
For getting away team score correct - 1 point.
Therefore, the max possible points per game would be 5.
So, for instance:

Home Away
3 1

john's prediction
2 1 4 points - 3 for the result and 1 for the
correct
away score
Jane's prediction
1 0 3 points for the correct result
Jack's prediction
0 3 0 points

I think there may be too many variables but any/all help greatly
appreciated.
--
tia