AnsweredAssumed Answered

Count script and a total.

Question asked by Billyboyo2004 on Jan 27, 2015
Latest reply on Feb 1, 2015 by Billyboyo2004


Count script and a total.


I have a list of competitors which varies with each event. I wish to allocate prizes to each event, but i don't know how to write the script. It would go some thing like this.

Count number of contestant 1....28 (28 being the maximum number of contestants)

if count = or < 3 then first prize

if count = or <  7 then second prize

if count = or > 7 then 3rd prize

I would need then to be able to total the $value of the event.

The initial layout would have a list with the prize money entered. eg: First Prize $10 Second Prize $8; Third prize $5.

Thanking you