League

Hi

Im currently making a small league table where i have listed all the fixtures for each team, with cells so the the scores can be entered.

I have a table where I have used If statement to work out points, for example i have, If one number is greater than the other then put in a one in the win cell of the team, if not a zero, once all fixtures are played this adds up fine as for the point i just times this wins cell by 3. this works for the games lost column also by reversing it to less than.

But my problem is the games drawn column where i have equals to if statement, then put in a one, but even though the scores are blank the table keeps reading that every team has drawn every game and gives the teams 1 point for every drawn game.


Sorry if this sound confusing, any advice

P.s. how can i sort a league according to points

Hi thanks for that that seems to do the trick,

but I forgot to ask another thing, I want to generate a random fixture list for 6 teams, playing one another once, is there a way that i can do this?