If, or & and functions

[Deaco]

Hello I hope I have the right place

I am trying to make a world cup score predictor to make it do the following:

correct results - 15 points (predicted 3-0 or 1-1, and the actual result is 3-0 or 1-1)
winning score only - 10 points (predicted 3-2, and the actual result is 3-0)
win or draw, no correct result - 5 points (predicted 1-0 or 1-1, and the actual result is 3-0 or 2-2)
any other result - 0 Points

I have gotten most of it to work so far using the formulae:
=IF(OR((A1>B1)-(C1>D1),(A1<B1)-(C1<D1)),0,IF(AND(A1=C1,B1=D1),15,5))

but struggling to integrate the winning score only option to earn 10 points

Any suggestions would be appreciated

[Special-K]

Try this (youll need to test this with a lot of results)

=IF(AND(A1=C1,B1=D1),15,IF(AND(C1<>D1,OR(AND(A1=C1,B1<>D1),AND(B1=D1,A1<>C1))),10,IF(OR(AND(A1>B1,C1>D1,A1<>C1),AND(B1>A1,D1>C1,B1<>D1),AND(A1=B1,C1=D1,A1<>C1)),5,0)))

I have a feeling this could be shortened as subsequent IFs may be already be implied by the failure of previous IFs, ie we may be checking for things we dont need to as a previous If would have been true but all I've done is simply check against your examples.

[Deaco]

Thankyou very much that works perfectly.