+ Reply to Thread
Results 1 to 5 of 5

Generating a random number

Hybrid View

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    82

    Generating a random number

    I need to generate a list of random numbers that are between 1 and 2, to 2 decimal places.

    How can I use RANDBETWEEN to do this please?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: Generating a random number

    Try this:

    =RANDBETWEEN(100,200)/100

    Hope this helps.

    Pete

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,300

    Re: Generating a random number

    Like this:

    =RANDBETWEEN(100,200)/100

    Make sure the cell formatting is set to two decimal places.

    Excel 2016 (Windows) 32 bit
    A
    1
    1.38
    2
    1.16
    3
    1.49
    4
    1.71
    5
    1.01
    6
    1.24
    7
    1.70
    8
    1.38
    9
    1.44
    Sheet: Sheet2
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Generating a random number

    I think
    Formula: copy to clipboard
    =RANDBETWEEN(100,200)/100

    should works.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,300

    Re: Generating a random number

    ... and then three come along all at once ...

+ 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. Generating Random Number with Probability
    By ixander in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-24-2016, 12:13 PM
  2. Generating random number
    By ASP__DEVELOPER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2012, 01:06 AM
  3. generating random number & 0s and 1s
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2011, 05:01 PM
  4. Random number generating
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-14-2010, 03:39 PM
  5. Generating a Random Number of Random Numbers
    By Garrus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2010, 09:39 AM
  6. Random Number Generating
    By tctees in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2008, 12:55 PM
  7. Generating Random Number from a set of numbers
    By CalsLib in forum Excel General
    Replies: 3
    Last Post: 03-17-2006, 12:27 PM

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