+ Reply to Thread
Results 1 to 2 of 2

Problem for rand(), between, vlookup?

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Mt. Pleasant, WI
    MS-Off Ver
    2007
    Posts
    1

    Problem for rand(), between, vlookup?

    I have this problem to set up:

    The color of a traffic light is green 40%, yellow 10% and red 50% of the time.
    I started with random numbers but figure I have to label these random numbers so they fall respectfully with the colors percentages. I can't
    figure our the formula to make it work

    green 0.1000 0.4999
    yellow 0.0000 0.0999
    red 0.5000 0.9999

    Green .1000-.4999 Yellow .0000- .0999 Red .5000-.9999
    Random# Result

    0.115020978 0.0000 0.0999
    0.44301443 0.1000 0.4999
    0.584649944 0.5000 0.9999
    0.444234756
    0.815282943
    0.523755545

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Problem for rand(), between, vlookup?

    Like attached?
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  2. Vlookup with rand()= #NA?
    By HPIMICHAEL02 in forum Excel General
    Replies: 4
    Last Post: 12-14-2012, 04:03 AM
  3. Rand Function Problem
    By ssjagger in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-12-2011, 02:41 PM
  4. Rand Time Problem
    By Wskip49 in forum Excel General
    Replies: 4
    Last Post: 01-29-2009, 04:07 AM
  5. Problem with "=rand()"
    By comotoman in forum Excel General
    Replies: 14
    Last Post: 09-22-2005, 03:03 PM

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