{"id":2755,"date":"2023-01-09T21:31:35","date_gmt":"2023-01-09T21:31:35","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=2755"},"modified":"2024-03-01T16:37:53","modified_gmt":"2024-03-01T16:37:53","slug":"how-to-generate-random-number-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-generate-random-number-in-excel\/","title":{"rendered":"How to Generate Random Number in Excel?"},"content":{"rendered":"

Generate Random Number in Excel to enhance your data analysis, simulation models, and decision-making processes. This versatile function opens up a world of possibilities, from creating unbiased samples to developing complex financial models. By incorporating randomness into your Excel projects, you can simulate various scenarios, improve security measures, and ensure fair and unbiased data distribution. Embrace the power of Excel’s random number generation to bring objectivity and innovation to your spreadsheets, making your analyses more robust and your conclusions more reliable.<\/p>\n

This Content Covers:<\/strong><\/p>\n

    \n
  1. Generate Random Numbers using the RAND function<\/strong><\/a><\/li>\n
  2. Generate Random Numbers using the RANDBETWEEN Function<\/strong><\/a><\/li>\n
  3. Generate Random Numbers with the Data Analysis tool<\/strong><\/a><\/li>\n
  4. Generate Random Numbers with VBA<\/strong><\/a><\/li>\n<\/ol>\n

    1. Generate Random Numbers using the RAND function<\/strong><\/h2>\n

    A decimal number between 0 and 1 is produced randomly by the RAND <\/strong>function.<\/p>\n

    Step 1:<\/strong> Select a cell, enter the formula given below and hit ENTER.<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 2:<\/strong> To get a list of random number just click and drag the lower right corner of that cell.<\/p>\n

    \"Generate<\/p>\n

    Step 3:<\/strong> The value in the first cell has changed because every time a cell on the sheet is calculated, new random numbers are generated. To prevent this just copy the random numbers using CTRL+C<\/strong> and right click on the cell you want to paste and paste them as Values<\/strong>. The formula bar now holds a value and not the RAND<\/strong> function.<\/p>\n

    \"Generate2. Generate Random Numbers using the RANDBETWEEN Function<\/strong><\/h2>\n

    The RANDBETWEEN function produces a random whole number between two limits.<\/p>\n

    Step 1<\/strong>: Choose a cell, type the formula below, then press Enter.<\/strong><\/p>\n

    = RANDBETWEEN ( bottom, top )<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 2<\/strong>: Modify the RAND function as follows to get random decimal values between 30 and 55.<\/p>\n

    =bottom+(top-bottom)*RAND()<\/strong><\/p>\n

    \"Generate<\/p>\n

    3. Generate Random Numbers with the Data Analysis tool<\/strong><\/h2>\n

    Step 1:<\/strong> Select Data>>Data Analysis.<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 2:<\/strong> From Data Analysis<\/strong> dialogue box Select Random Number Generation<\/strong> and hit OK.<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 3: <\/strong>From Random number Generation<\/strong> dialogue box select Uniform<\/strong> in Distribution box,<\/strong> then set the top and bottom value inside the boxes labeled as Between.<\/strong> Select the Output Range <\/strong>box option and select the cell you want to put the random number in and hit OK.<\/strong><\/p>\n

    \"Generate4. Generate Random Numbers with VBA<\/strong><\/h2>\n

    Generating random numbers using VBA is a bit complex process.<\/p>\n

    Step 1:<\/strong> Right click on your current worksheet and select View Code.<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 2: <\/strong>Insert the formula given below inside the VBA module dialogue box and click RUN.<\/strong><\/p>\n

    Sub RandomNumber()<\/strong><\/p>\n

    \u00a0\u00a0\u00a0 MsgBox Rnd()<\/strong><\/p>\n

    End Sub<\/strong><\/p>\n

    \"Generate<\/p>\n

    Step 3: <\/strong>After you hit the RUN a dialogue box will appear consisting of a random number.<\/p>\n

    \"Generate<\/p>\n

    Application of Generate Random Number in Excel<\/strong><\/h2>\n