Formula Help - please

[killerkok]

Hey i have just started using TD2 as this software i smuch better than the one i am used too.

but i need a little help writing a formula for the program.

i want to create a league where every player is added points on the following criteria

4 + Outlast + (number of players/ place) this is the formula i use in an excel spreedsheet

and i want to change it with the following things

player should still get get the points that the other formula creates

then they should get 1 point for every player the bust out of a tournament during the season

and they are only given the top 10 results + 4 points for being there + 1 point for every player busted in every tournament

is this possible

if i am inclear please say so

Henrik

[Corey Cooper]

I think you might need to describe in a little more detail what you need.

4 + Outlast + (number of players/ place)

I assume by "outlast" you mean 1 point for each player that has already busted out.  In other words, with a 10 player tournament, the player to bust out in 6th place gets 4 points, because he/she outlasted 4 other players (7th through 10th place).

But I don't know what you mean by "(number of players/ place)".

[killerkok]

i got a friend who wrote the formula to excel to send it to me

so the original formula as it looks in excel is : 4 + (n/r) + (n-r)

and it works in TD2 as well, so no problem there

so the question is, can the following to things be added to this formula

only top 10 results count

1 point for each player that you bust in all tournaments

and by the way thanks for the quick reply

//Henrik

[Corey Cooper]

if(r < 11, 4 + (n/r) + (n-r) + nh)