Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

PAYOUT FORMULA HELP

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
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    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
    ------------------------------