ReneeHansen
Qrew Member
3 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
------------------------------