+ Reply to Thread
Results 1 to 2 of 2

Random Raffle with a Budget

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    U.S.
    MS-Off Ver
    2012
    Posts
    1

    Question Random Raffle with a Budget

    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!

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Random Raffle with a Budget

    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
    How about setting up a winning pattern with 50 rows (25% of 200) and in cell B2 you enter $65, then in cell B3 and B4 you have the value $45 so you split up your $1000 in proportions down to $1 and then you use the RAND function in column A to pick the winning numbers (empoyees 1 to 200)?

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Weighted Random Number Generator for Raffle
    By nycraray6 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-09-2019, 05:06 AM
  2. Replies: 2
    Last Post: 03-15-2017, 03:14 AM
  3. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  4. budget formula. 2 different formulas for yearly budget SUMIF?
    By italianstallion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 05:20 AM
  5. Pulling weekly budget data into monthly budget
    By MarkRabbit in forum Excel General
    Replies: 4
    Last Post: 10-19-2008, 04:28 PM
  6. Divide Monthly Sales Budget to Day budget
    By Benedikt Fridbjornsson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2006, 03:25 PM
  7. [SOLVED] Divide Monthly Sales Budget to Day Budget
    By Benedikt Fridbjornsson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2006, 11:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1