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
------------------------------