"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.

"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.

"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.

"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.

"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.

"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.