Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
3 years ago

Error with "expecting bool, number" please help! :)

I'm trying to create a formula to calculate a prize payout.

I'm getting an error at the end with the parenthesis - it says "Expecting bool, number"

I'm not sure what that means. Is anyone available to help? Thank you!

the formula I have now is:

Floor(If([# OF PLAYERS FOR EVENT 06-19]<=4 and [Place]=1,([PRIZE POOL COST]*0.6),
If([# OF PLAYERS FOR EVENT 06-19]<=4 and [Place]=2, ([PRIZE POOL COST]*0.4),

If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19] >=5 and [Place]=1,([PRIZE POOL COST]*0.4),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19] >=5 and [Place]=2,([PRIZE POOL COST]*0.3),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19]>=5 and [Place]=3,([PRIZE POOL COST]*0.2),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19]>=5 and [Place]=4,([PRIZE POOL COST]*0.1),

If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]=1,([PRIZE POOL COST]*0.3),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]=2,([PRIZE POOL COST]*0.25),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]=3,([PRIZE POOL COST]*0.2),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]=4,([PRIZE POOL COST]*0.15),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]=5,([PRIZE POOL COST]*0.1),

If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]=1,([PRIZE POOL COST]*0.29),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]=2,([PRIZE POOL COST]*0.24),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]=3,([PRIZE POOL COST]*0.19),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19]>=16 and [Place]=4,([PRIZE POOL COST]*0.14),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]=5,([PRIZE POOL COST]*0.09),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]=6,([PRIZE POOL COST]*0.05),

)))))))))))))))))))))))



------------------------------
Renee Hansen
------------------------------
No RepliesBe the first to reply