1

**Help Me / Points formula using "in the money" as a variable**

« **on:**October 22, 2006, 09:11:11 PM »

Hello there,

I'm looking to see if anyone can give me some assistance in "automating" my points formula. My points formula currently needs to be manually adjusted whenever there is a change in the amount of players that place in the money.

For example, if there are 3 money winners, my formula would look like this:

round((n-r+1)*(n-r+1)/n*100+n*25/3*max((3-r+1),0))

If there are 4 money winners, my formula would be this:

round((n-r+1)*(n-r+1)/n*100+n*25/4*max((4-r+1),0))

I would love to be able to find a formula that would automate this, so that I didn't have to manually change these numbers when there is a change in money winners. I have been trying to use the "in the money" (m) variable, but I can't seem to put together something that will work for me.

Any help with this would be appreciated.

I'm looking to see if anyone can give me some assistance in "automating" my points formula. My points formula currently needs to be manually adjusted whenever there is a change in the amount of players that place in the money.

For example, if there are 3 money winners, my formula would look like this:

round((n-r+1)*(n-r+1)/n*100+n*25/3*max((3-r+1),0))

If there are 4 money winners, my formula would be this:

round((n-r+1)*(n-r+1)/n*100+n*25/4*max((4-r+1),0))

I would love to be able to find a formula that would automate this, so that I didn't have to manually change these numbers when there is a change in money winners. I have been trying to use the "in the money" (m) variable, but I can't seem to put together something that will work for me.

Any help with this would be appreciated.