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.