View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhtak
 
Posts: n/a
Default Another "World Cup" related query

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.