16
Help Me / Question about formula's
« on: July 15, 2010, 07:33:54 AM »
Just a quick question.
I know nothing about formula's, got all the info off here, got help to set it up.
It's only a simple one, I had already set up all my points for playing and all the other stuff
so I just added the formula for using the best 10 results from 12.
This works great.
The question is:
How does the formula work ?, at the end off the season easy, it will use the best 10 results from the 12 games for everyone.
If a player has missed a game it will in this case use the best 10 from 11, hope so anyway.
My players are asking can they see what the league table would look like with your worst 2 results omitted.
So when I do a table every month could I change the formula to say best 2 from 4 or best 6 from 8, if so what happens
with players that have missed games ?
Any help please.
I know nothing about formula's, got all the info off here, got help to set it up.
It's only a simple one, I had already set up all my points for playing and all the other stuff
so I just added the formula for using the best 10 results from 12.
This works great.
The question is:
How does the formula work ?, at the end off the season easy, it will use the best 10 results from the 12 games for everyone.
If a player has missed a game it will in this case use the best 10 from 11, hope so anyway.
My players are asking can they see what the league table would look like with your worst 2 results omitted.
So when I do a table every month could I change the formula to say best 2 from 4 or best 6 from 8, if so what happens
with players that have missed games ?
Any help please.