Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another "World Cup" related query
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another "World Cup" related query
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another "World Cup" related query
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing query source | Excel Worksheet Functions | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |