A new formula needed

[mikkelkk]

Hi,
First of all, thanks for a great piece of software!

I am trying to create a formula for the tournament scoring for my home poker league (8-10 players), but can't figure out a good formula. I want it to favour the first 3 positions and also take into account the number of hits and the size of the prize pool.

I have tried with something like this: ((log10(pp))*(log10(pp))+sqrt(n)+nh)/(1+r)
But I would prefer to have a formula not resulting in points with weird decimals. I know using the LOG function should then be avoided, but need some inspiration from you guys ;-)

I have also tried this: (pp/(n*10))+nh+(sqrt((n/r)*10)) but I would like it to favour the top 3 a bit more.....

All suggestions are welcome!

[edneely]

I'm new to this feature.  Is their a ROUND function?

[Corey Cooper]

Yes.  Oddly enough, it's "round()". 

There's also a "ceil()" function to round up, and a "floor()" function to round down.  "round()" rounds to the nearest.