Easy. When used in a calculation, a logical value of TRUE will count as 1,
and a FALSE counts as zero.
--
David Biddulph

"JockW" wrote in message
...
I don't get it, but it works....

thanks.

"David Biddulph" wrote:

If the actual result is in cells B2 and C2 (home & away), and the
predictions from your contestants are in the same columns in rows 4
onwards,
then in D4 you can put the formula
=3*(SIGN(B4-C4)=SIGN(B$2-C$2))+(B4=B$2)+(C4=C$2), and copy down as
required.
--
David Biddulph

"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