+ Reply to Thread
Results 1 to 4 of 4

Random Number Based on Chances of Happening

  1. #1
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Random Number Based on Chances of Happening

    I have 5 numbers which are 1, 2, 3, 4 and 5.

    Number 1 has a 80% chance of occurring. Number 2 has a 10% chance of occurring. Number 3 has a 8.5% chance. Number 4 has a 1% chance and Number 5 has a 0.5% chance.

    What formula do I need to randomly choose one of my numbers (1, 2, 3, 4 or 5) based on the likelihood of them occurring?
    Last edited by ScabbyDog; 03-02-2016 at 05:10 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Random Number Based on Chances of Happening

    Please Login or Register  to view this content.
    Try the above formula
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Re: Random Number Based on Chances of Happening

    Solved. Thanks.

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Random Number Based on Chances of Happening

    Thanks for your feedback and adding reputation

+ 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. Calculating the number of concurrent calls that were happening when call started
    By urbanbumpkin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-24-2015, 11:18 AM
  2. [SOLVED] Auto Replicate data to new rows based on number of chances
    By AriesCastillo in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-24-2014, 04:59 AM
  3. Replies: 0
    Last Post: 02-01-2013, 09:26 PM
  4. Number formatting not happening
    By luckyros in forum Excel General
    Replies: 1
    Last Post: 03-23-2011, 01:10 AM
  5. Show last 3 chances
    By Archimede in forum Excel General
    Replies: 4
    Last Post: 10-06-2009, 05:55 PM
  6. Need VBA code for Rnadom Number Generator
    By Shani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2006, 11:33 AM
  7. Terrible Excel Ruined My Chances of Graduation
    By David in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 05:10 AM
  8. Password - 3 chances and **off
    By Shake in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2005, 04:56 AM

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