Another "World Cup" related query
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?
"Andy" wrote:
Thanks for the feedback - glad to help.
Andy.
"yhtak" wrote in message
...
Thanks... just what I needed!
"Andy" wrote:
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(C2D2,G2H2),AND( C2<D2,G2<H2)),1,0))
Andy.
"yhtak" wrote in message
...
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.
|