Author Topic: Formula problem  (Read 1076 times)

mikkelkk

  • Newbie
  • *
  • Posts: 11
    • View Profile
Formula problem
« on: October 29, 2009, 09:15:33 AM »
I am trying use the following formula for tournament scoring:

ROUND((((10+nh)*n)/(r+0,5))+((pp/n)/(n+r)))

When I test it using an excel sheet with the following values: nh=0, r=1, pp=300, n=8 I get 58
When I test it TD I get a value of 20....

In excel I get the following values:

1st. 58   
2nd.36   
3rd.26   
4th. 21   

What am I doing wrong in TD?

Any help is appriciated, thanks!
Mikkel

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula problem
« Reply #1 on: October 29, 2009, 09:46:07 AM »
The comma should be a period.

mikkelkk

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: Formula problem
« Reply #2 on: November 03, 2009, 01:48:17 PM »
Of course ;-) Thanks a lot! Such a simple solution but still one I couldn't figure out.