The Tournament Director Forums

Main => Help Me => Topic started by: bmontana33 on December 08, 2012, 01:20:55 PM

Title: Formula error
Post by: bmontana33 on December 08, 2012, 01:20:55 PM
I'm hosting a game tonight, the last tourney before our league and I wanted to test out the points formula before the league started just to make sure everything is working ok. But when I tried to test the formula I get an error. What is wrong with the following formula:

10*(SQRT(n/r)) - (nr)

Thanks
Title: Re: Formula error
Post by: Corey Cooper on December 08, 2012, 04:31:33 PM
There's nothing wrong with your formula.  But since it has a division operation, if you don't set the value of "r" (rank), it may have a default value of 0 (which would be odd but not impossible), and thus your formula would have "n/0" which results in a "division by zero error", since you can't divide something by zero.