"World Cup" query #2

[Guest]

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

 

[Bob Phillips]

=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2>D2,G2>H2),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)

 

[Bernard Liengme]

Try
=IF(AND(C2=G2,D2=H2),3,IF(C2-D2=G2-H2,1,0))
best wishes

 

[Bernard Liengme]

This is what I meant to code!

 

[Guest]

Thank for solving the problem.

=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2>D2,G2>H2),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)

 

[Guest]

Thank you for taking the trouble to post the answer.