Hello, I would like to hold a raffle for my employees with the following conditions:
- 25% of the 200 employees will receive a random prize.
- I have a max budget of $1000 dollars.
- Prizes range anywhere from $1 to $65 (there are 65 different prizes). I can only spend $1000 cumulatively.
Could anyone point me in the right direction on how to create this? I've tried using RAND, but it does not take into account that I cannot spend more than $1000 and that I want 25% of the employees to win. Thank you for any help!
Bookmarks