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.