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.

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.

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.

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.

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.