Hi,
I'm hoping someone can help Im trying to create a website to rank football teams based on an ELO ranking system similar to what chess players use... basically both teams start with 1000 points... the home team gives 7* of their 1000 points into a kitty and the away team gives 5% of their ranking points. The winning team takes all the points. I cant upload the spreadsheet, so Ive included the formula Ive used and a screenshot of the spreadsheet. I can get it to work for either the home team or away team but not for both... anyway this is the current formula
=IF(AND($C3=$F$1:$Y$1,$E3="a"),F2*0.07+(0.05*LOOKUP($A3,$F$1:$Y$1,$F2:$Y2)+F2),IF(AND($C3=$F$1:$Y$1,$E3="h"),F2-(F2*0.05+(0.07*LOOKUP($A3,$F$1:$Y$1,$F2:$Y2))),F2))
And this is how Ive set up the spreadsheet
Untitled.jpg
Thanks for any help
Regards
Mike
Bookmarks