Hi everyone!

I need help some formula help for this raffle I need to run. Here are the mechanics:

1) If participants reach the following quota of emails answered, they earn the corresponding raffle entries:
A target of 50, 1 raffle entry per email answered
Between 51-100, 2 raffle entries per email answered
Between 101-150, 3 raffle entries per email answered
Between 151-200, 4 raffle entries per email answered
Between 201-250, 5 raffle entries per email answered
2) If for example, a participant answers answers 100 emails, then another sheet should generate his/her name 200 times. If a participant answers 200 emails, the other sheet should generate his/her name 400 times. So on and so forth.

The promo will run for 5 days so I hope this sheet can be populated as easy as possible.

Hope anyone here can help out!

Thanks!