+ Reply to Thread
Results 1 to 10 of 10

Generating random outcomes based on probability

Hybrid View

JP2008 Generating random outcomes... 02-10-2009, 01:47 PM
ChemistB Re: Generating random... 02-10-2009, 02:00 PM
JP2008 Re: Generating random... 02-10-2009, 02:54 PM
ChemistB Re: Generating random... 02-10-2009, 03:01 PM
Aakanaar Re: Generating random... 02-10-2009, 04:07 PM
shg Re: Generating random... 02-10-2009, 04:15 PM
ChemistB Re: Generating random... 02-10-2009, 05:50 PM
lewisteamx Re: Generating random... 12-04-2015, 09:50 AM
ChemistB Re: Generating random... 12-04-2015, 10:02 AM
lewisteamx Re: Generating random... 12-07-2015, 04:48 AM
  1. #1
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Generating random outcomes based on probability

    =LOOKUP(RAND(), {0,0.5,0.8}, {"Dog","Cat","Rabbit"})
    Entia non sunt multiplicanda sine necessitate

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Generating random outcomes based on probability

    Nice Shg! I keep forgetting the lookup function. ::Smacks head::::
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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