Skip to main content
Question

PAYOUT FORMULA HELP

  • September 23, 2021
  • 0 replies
  • 13 views

I have a formula that someone in the Care team helped put together for  me, about 5 months ago. And I'm just now able to use it/make it work.

I'm getting an error:

Also, see the 2 attached screenshots.
Floor(

If([# of SCORE CARDS 09-25]<=4 and [PLACE]="1",[09-25 PRIZE POOL]*0.6),
If([# of SCORE CARDS 09-25]<=4 and [PLACE]="2", [09-25 PRIZE POOL]*0.4), (<--- here is the error)

If([# of SCORE CARDS 09-25]<=10 and [# of SCORE CARDS 09-25] >=5 and [PLACE]="1",[09-25 PRIZE POOL]*0.4),
If([# of SCORE CARDS 09-25]<=10 and [# of SCORE CARDS 09-25] >=5 and [PLACE]="2",[09-25 PRIZE POOL]*0.3),
If([# of SCORE CARDS 09-25]<=10 and [# of SCORE CARDS 09-25]>=5 and [PLACE]="3",[09-25 PRIZE POOL]*0.2),
If([# of SCORE CARDS 09-25]<=10 and [# of SCORE CARDS 09-25]>=5 and [PLACE]="4",[09-25 PRIZE POOL]*0.1),

If([# of SCORE CARDS 09-25]<=15 and [# of SCORE CARDS 09-25] >=11 and [PLACE]="1",[09-25 PRIZE POOL]*0.3),
If([# of SCORE CARDS 09-25]<=15 and [# of SCORE CARDS 09-25] >=11 and [PLACE]="2",[09-25 PRIZE POOL]*0.25),
If([# of SCORE CARDS 09-25]<=15 and [# of SCORE CARDS 09-25] >=11 and [PLACE]="3",[09-25 PRIZE POOL]*0.2),
If([# of SCORE CARDS 09-25]<=15 and [# of SCORE CARDS 09-25] >=11 and [PLACE]="4",[09-25 PRIZE POOL]*0.15),
If([# of SCORE CARDS 09-25]<=15 and [# of SCORE CARDS 09-25] >=11 and [PLACE]="5",[09-25 PRIZE POOL]*0.1),

If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 and [PLACE]="1",[09-25 PRIZE POOL]*0.29),
If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 and [PLACE]="2",[09-25 PRIZE POOL]*0.24),
If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 and [PLACE]="3",[09-25 PRIZE POOL]*0.19),
If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25]>=16 and [PLACE]="4",[09-25 PRIZE POOL]*0.14),
If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 and [PLACE]="5",[09-25 PRIZE POOL]*0.09),
If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 and [PLACE]="6",[09-25 PRIZE POOL]*0.05)
)



------------------------------
Renee Hansen
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • September 23, 2021
Try deleting the ) in line 3.  If the error drops down a line then continue removing the ) in each line except the last line that starts with "If([# of SCORE CARDS 09-25]<=20 and [# of SCORE CARDS 09-25] >=16 ..."  

------------------------------
Paul Peterson
------------------------------