There's probably a more elegant solution out there, but this should work:

=IF(A2=$A$1,1,0)+IF(B2=$B$1,1,0)+IF(OR(AND(A2B2,$ A$1$B$1),AND(A2<B2,$A$2<$B$2),AND(A2=B2,$A$1=$B$1 )),3)

This assumes your actual score is in A1 and B1, with your 1st guess scores
in A2 and B2.

HTH,
Elkar


"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