Author Topic: Formua I use wonlt work in TD  (Read 2228 times)

flipflop1970

  • Newbie
  • *
  • Posts: 12
    • View Profile
Formua I use wonlt work in TD
« on: May 03, 2007, 08:42:00 AM »
roundup(((sqrt (buyin * entries) ) / (finish+ 1.0))*2),1)

this is the formula I use in excel,  but when i test it says there is an error in TD.

Do I have to have all other info for the tourney to be entered to make sure it wrks

I replaced the buyin, entries, and finsih with the correct letters for formula

flipflop1970

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #1 on: May 03, 2007, 08:47:22 AM »
((sqrt(bc* n))/(r+ 1))*2)

this si what i have tried with a 50.00 buy in and a 20 player tournament

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #2 on: May 03, 2007, 08:57:59 AM »
round((sqrt(bc*n))/(r+1)*2)

I tested that one in TD and it works so far as TD accepting it as a formula

flipflop1970

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #3 on: May 03, 2007, 09:03:08 AM »
round((sqrt(bc*n))/(r+1)*2)

I tested that one in TD and it works so far as TD accepting it as a formula

ty you that worked...

flipflop1970

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #4 on: May 03, 2007, 09:46:53 AM »
here is the new formula I am using now. 

this works better

round(sqrt(((bc*n)/(r+1)))/r)+(n-r)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #5 on: May 03, 2007, 11:12:29 AM »
There is no "roundup" function.  But as you obviously figured out, there is a "round" function, which rounds to the nearest (either up or down).  If you want to always round up, just add .5:  round(<whatever> + .5)

round((sqrt(((bc*n)/(r+1)))/r) + .5)+(n-r)

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #6 on: May 03, 2007, 02:26:01 PM »
hey good tip on the .5 round up... simple but I never would have thought of that

CanopicJar

  • Full Member
  • ***
  • Posts: 128
    • View Profile
    • The Back Door Holdem blog
Re: Formua I use wonlt work in TD
« Reply #7 on: May 03, 2007, 02:38:48 PM »
Shouldnt you add .4 or .49 instead of .5 to prevent rounding an even number up one? 

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: Formua I use wonlt work in TD
« Reply #8 on: May 03, 2007, 03:34:47 PM »
Doh!  I believe I meant "floor" instead of "round".  To round a number up, use floor(n + .5).  Of course, now that I've started thinking again, the ceil() function is exactly what you are looking for.

<bonking head on desk>