Results 1 to 4 of 4

Random Number Based on Chances of Happening

Threaded View

  1. 03-02-2016, 05:00 AM #1
    ScabbyDog
    ScabbyDog is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. % of chances to answer correctly a QCM question with variable knowledge players
    By Askalian in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1