Populating raffle entries in Excel or Google Sheets

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!

This is so useful, Martin. Thanks so much!

Can I still ask for your help in updating the formulas? We have different categories that I plan to run on different sheets within the same workbook:

A) Up to 125, 1 raffle entry per email answered
[50% above 125] Between 126-188, 2 raffle entries per email answered
[100% above 125] Between 189-250, 3 raffle entries per email answered
[150% above 125] Between 251-313, 4 raffle entries per email answered
[200% above 125] Between 314-375, 5 raffle entries per email answered

B) Up to 80, 1 raffle entry per email answered
[50% above 80] Between 81-120, 2 raffle entries per email answered
[100% above 80] Between 121-160, 3 raffle entries per email answered
[150% above 80] Between 161-200, 4 raffle entries per email answered
[200% above 80] Between 201-240, 5 raffle entries per email answered

C) Up to 80, 1.5 raffle entries per email answered
[50% above 80] Between 81-120, 3 raffle entries per email answered
[100% above 80] Between 121-160, 4.5 raffle entries per email answered
[150% above 80] Between 161-200, 6 raffle entries per email answered
[200% above 80] Between 201-240, 7.5 raffle entries per email answered

D) Up to 60, 1.5 raffle entries per email answered
[50% above 60] Between 61-90, 3 raffle entries per email answered
[100% above 60] Between 91-120, 4.5 raffle entries per email answered
[150% above 60] Between 121-150, 6 raffle entries per email answered
[200% above 60] Between 151-180, 7.5 raffle entries per email answered

It's a lot to ask but anything you can will be a huge help.

Thanks so much again!