I posted this in excel.worksheetfunctions as well, but thought I'd try here
too...

I'm trying to come up with something that would allow a breakdown of payouts
for a tournament, based on the number of entries.

Say I wanted to pay 1 in 4(pay one place for every 4 entries). I'd like to
be able to enter the number of entries, the amount going into the prize fund
for each entry, and the percentage being paid to first place, then let the
sheet calculate how many more places I'd pay, and distribute the remaining
amount among those places.

Any ideas?

Thanks!
Shawn


--
It's not just based on number of championships won. Richard Petty won
200 races and 7 Daytona 500s in his 30+ year driving career. He also has
the most top-5s (555), top-10s (712), poles (126), laps completed
(307,836), laps led (52,194), races led (599) and consecutive races won
(10 in 1967) of any driver in NASCAR history.