Excel Formula for Football Scores

cool

Yeah, thanks to you, it's cool.

Hello,
let G3, H3 be the two teams
the points awarded by the following formula are: 2 points for a draw, 1 point for losing, 4 points for winning
=IF(AND(ISNUMBER(G3),ISNUMBER(H3),G3=H3),2,IF(AND(ISNUMBER(G3),ISNUMBER(H3),G3

H3),4,""))
I hope this will work for you.

Thank you for your help but I don't see how you take into account the score format.

Example:

If the match is won with the exact result => 3 points, if won but the result is not exact then 1 point, otherwise 0 points

MATCH SCORE LOTO FOOT
Arsenal/Chelsea 0-0 0-1
REAL/MILAN 1-0 2-1
Liverpool/Reds 1-2 0-2

but how can you compare a result in the following format 0-1 how will excel understand?

I want to be able to enter a score in this format in a cell 0-1
and compare it to another score (lotto foot forecast) to assign points based on the results.

Example:

France/Italy => score = 0-1 lotto foot = 0-2 so the bettor gets a point because Italy wins but with a different score.

I want to be able to assign these points using an Excel formula.

Yes, it's a score per cell. If you have an email, I'll send you the file for better understanding.

I will test and keep you updated.

lolllllll no I'm doing it right now

But alas it doesn't work

Match Score prediction Points
Bordeaux - Nancy 2 1 2 0 1
Valenciennes - Lyon 1 2 1 1 0
Sochaux - Nice 1 0 1 1 0
Le Mans - Caen 1 1 0 0 1
Lille - Auxerre 0 2 2 0 0
Metz - Toulouse 0 2 1 0 0
Lorient - Marseille 1 2 1 0 0

If the prediction is correct but the score is not exact then 1 point, if the score is exact then 3 points, otherwise 0 points.

What I don't understand is why we need to make several formulas:

Let me explain

to understand well I will put the cells:

-----Result A1 B1--------- Prediction C1 D1
--------------------2 1 -------------------- 3 1
so we get 1 point because the match is won but the result is inaccurate.

Points in cell => E1
=IF(AND(A1=C1;B1=D1;3);IF(AND(A1>C1;B1>D1);1);IF(AND(A1<c1 />

This one still doesn't work very well.

Did you not understand?

Give me your email and I'll send you my file and you'll see.

But that's how I went about it, and I just did it again like you and it still doesn't work; I'm about to admit defeat by Excel

For your information, I am male lol

Here are the 2 formulas (1=you, 2=me)

IF(AND(A1=C1,B1=D1,3),IF(AND(A1>C1,B1>D1),1),IF(AND(A1<c1 />IF(AND(A1=C1,B1=D1),3,IF(AND(A1>B1,C1>D1),1,IF(AND(A1<b1 />
At my place, it works without any problems ;-(

Yes, but it doesn't work on all tests

-----Result --A1 B1--------- Prediction C1 D1
--------------------0 2 -------------------- 2 0
therefore, we get 0 points because the match is lost

Try it, you'll see

We get 1 when we should get 0 since the match is lost

Reminder:

Match won with the exact score = 3 points, won but incorrect score = 1 point and all other cases = 0 points

Yes, it's better now but it still doesn't handle all the tests:

I've just noticed that when a match ends in a tie but with an incorrect score, it gives 0 instead of 1, even though we should get 1 since the match is tied.

Illustration:

-----Result --A1 B1--------- Prediction C1 D1
--------------------1 1 -------------------- 2 2

To solve this problem, I added this series => if(and(a1-b1=0;c1-d1=0);1;0) but it only works when the tie is correct but the score is exact.

But also in this case it doesn't work

-----Result --A1 B1--------- Prediction C1 D1
--------------------0 --0 -------------------0-- 1

I hope I'm not being a burden.

Ok, I'm checking but before I eat, enjoy your meal!

Perfect, it works, at least I've tested it in several cases and there are no errors.

What do you do in life? Do you know a bit about VBA programming?