Another "World Cup" related query

[Guest]

Apologies if this query has been raised before...

We are running a "predict the score" syndicate and I am trying to write a
fomula to generate the following points score e.g.

if the predicted score is say, 3-0 and the actual score is 3-0 then you get
3 points
if the predicted/actual score is incorrect but the RESULT is correct - you
get 1 point
if the predicted score is, say 3-0 but the result is 0-3, you get 0 points.

Any assistance will be gratefully received.

 

[Guest]

Hi

With your actual score in C2 and D2 and your predicted score in G2 and H2,
try something like this:
=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2>D2,G2>H2),AND(C2<D2,G2<H2)),1,0))

Andy.

 

[Guest]

Thanks... just what I needed!

Hi

With your actual score in C2 and D2 and your predicted score in G2 and H2,
try something like this:
=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2>D2,G2>H2),AND(C2<D2,G2<H2)),1,0))

Andy.

 

[Guest]

Thanks for the feedback - glad to help.

Andy.

Thanks... just what I needed!

 

[Guest]

Hi again,

I've just discovered that if the predicted score was 0-0 and the actual
score was 1-1 the formula returns a value of 0 instead of 1 (for a correct
result). How should I adjust for formula please?