=IF(OR(AND($A$2$B$2,A4B4),AND($A$2<$B$2,A4<B4),A ND($A$2=$B$2,A4=B4)),3,0)+--($A$2=A4)+--($B$2=B4)

Assume Actual Home and Away scores are an A2 and B2 and predicted scores are
in A4 and B4 down

Regards

Trevor


"JockW" wrote in message
...
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