Forum Discussion

jberlin's avatar
jberlin
Copper Contributor
Nov 02, 2020
Solved

Formula for choosing a winner (weighted)

Hello - I have tasked with choosing a winner for a contest that was run by my company. A contestant has increased odds of winning based on the employees sales total. ie:

  • $1,000 raised equals one entry
  • $2,500 raised equals two entries
  • for every additional $2,500 raised, 1 additional entry is given

Does anyone have any formula suggestions to serve as a solution to randomly picking a winner based on the above criteria? Thank you in advanced! 

9 Replies

No RepliesBe the first to reply

Resources