Author Topic: Formula error  (Read 950 times)

bmontana33

  • Newbie
  • *
  • Posts: 47
    • View Profile
Formula error
« 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

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula error
« Reply #1 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.