KingofKings
New Member
- Joined
- Nov 26, 2005
- Messages
- 1
Hello.
OK, what I'm doing is basically tallying up a series of tournaments in order to show overall winners. I have a formula to do that- that is no problem.
What I need to do however is for every one of these individual tournaments is to get a score. The first tournament there are 64 entrants and I want to gte a score out of 128.
The first person #1 should have a score of 127 (just to bring it on par with the other tournaments of 128 I am comparing it with.
The second: score 125
The second last: score 3
Last score 1 (just to make it one better that if the tournament was not entered at all.
To do this i have used the formula =129-1*(2*C5) (where C5 was their place in the tournament).
The problem I have is that I am using a bakers dozen numbers of tournaments and in each one slightly different people contested. Some people were in every tournaments, some were in a few and others may have only been in one.
The trouble I have is that when a person did not enter a tournament he gets a placing of "0", which means that point wise he gets 129, which is better than first place.
In actuality I want him to get 0. How can i put some kind of limit so that the calculation is only done if the placing is greater than 0 (ie 1 and up)? But if the placing is zero, then the points will come to be zero)?
Sorry if that was hard to follow, you probably didn't need to know the background of what I needed, but there it is.
Please help me someone.
Cheers.
OK, what I'm doing is basically tallying up a series of tournaments in order to show overall winners. I have a formula to do that- that is no problem.
What I need to do however is for every one of these individual tournaments is to get a score. The first tournament there are 64 entrants and I want to gte a score out of 128.
The first person #1 should have a score of 127 (just to bring it on par with the other tournaments of 128 I am comparing it with.
The second: score 125
The second last: score 3
Last score 1 (just to make it one better that if the tournament was not entered at all.
To do this i have used the formula =129-1*(2*C5) (where C5 was their place in the tournament).
The problem I have is that I am using a bakers dozen numbers of tournaments and in each one slightly different people contested. Some people were in every tournaments, some were in a few and others may have only been in one.
The trouble I have is that when a person did not enter a tournament he gets a placing of "0", which means that point wise he gets 129, which is better than first place.
In actuality I want him to get 0. How can i put some kind of limit so that the calculation is only done if the placing is greater than 0 (ie 1 and up)? But if the placing is zero, then the points will come to be zero)?
Sorry if that was hard to follow, you probably didn't need to know the background of what I needed, but there it is.
Please help me someone.
Cheers.
