| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"World Cup" query #2
What if the predicted score is 0-0 and the result is 1-1 - using this formula
the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"World Cup" query #2
=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2D2,G2H2),AND( C2<D2,G2<H2),C2-G2=D2-H2),
1,0)) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "yhtak" wrote in message ... What if the predicted score is 0-0 and the result is 1-1 - using this formula the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"World Cup" query #2
Try
=IF(AND(C2=G2,D2=H2),3,IF(C2-D2=G2-H2,1,0)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "yhtak" wrote in message ... What if the predicted score is 0-0 and the result is 1-1 - using this formula the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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
|
|||
|
|||
|
"World Cup" query #2
This is what I meant to code!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bob Phillips" wrote in message ... =IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2D2,G2H2),AND( C2<D2,G2<H2),C2-G2=D2-H2), 1,0)) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "yhtak" wrote in message ... What if the predicted score is 0-0 and the result is 1-1 - using this formula the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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
|
|||
|
|||
|
"World Cup" query #2
Thank for solving the problem.
"Bob Phillips" wrote: =IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2D2,G2H2),AND( C2<D2,G2<H2),C2-G2=D2-H2), 1,0)) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "yhtak" wrote in message ... What if the predicted score is 0-0 and the result is 1-1 - using this formula the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"World Cup" query #2
Thank you for taking the trouble to post the answer.
"Bernard Liengme" wrote: Try =IF(AND(C2=G2,D2=H2),3,IF(C2-D2=G2-H2,1,0)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "yhtak" wrote in message ... What if the predicted score is 0-0 and the result is 1-1 - using this formula the points score is shown as 0 but it should show as 1 (for a correctresult) can anyone help me .... the original query is as shown below. Many thanks "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 | |||
| Another "World Cup" related query | Excel Discussion (Misc queries) | |||
| changing query source | 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) | |||
Linear Mode
