Hello guys,
Maybe someone could help to create formula, which could calculate points of football predictions?
Rules are:
For correct result - 4 points
For correct winner+goals margin - 2 points
For only correct winner - 1 point
Otherwise - 0
There's an example attached
I hope someone would be able to help me.
In G2 and copied down:
=IF(AND(E2=$C2,F2=$D2),4,IF((E2-F2)=($C2-$D2),2,IF(AND(E2>F2,$C2>$D2),1,IF(AND(E2<F2,$C2<$D2),1,0))))
Then you can copy this to the other players.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you
You're welcome!
Hi, thank you for the formula Ali, it has helped me. Can I ask what if there is no predicted score entered, can that formula then be amended to return a 0?
Thanks
Andy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks