Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel OFFSET function
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel ROW Function
  • How to use Excel MATCH Function

Data Analysis Examples

  • Conditional Formatting Color Scales Examples in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Filter Data in Excel
  • Remove Duplicates Example in Excel
  • Understanding Pivot Tables in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Excel Data validation unique values only
  • Excel Data validation date in next 30 days
  • Data validation must not exist in list
  • Prevent invalid data entering in specific cells

RAND vs RANDBETWEEN function examples in Excel

by
Excel has two useful functions when it comes to generating random numbers.
The RAND and RANDBETWEEN function.

Rand

The RAND function generates a random decimal number between 0 and 1.

1. Select cell A1.

2. Type RAND() and press Enter. The RAND function has no arguments.

Worked Example:   Randomize/ Shuffle List in Excel

3. To generate a list of random numbers, select cell A1, click on the lower right corner of cell A1 and drag it down.

Note that cell A1 has changed. That is because random numbers change every time a cell on the sheet is calculated.

Worked Example:   How to fill cell ranges with random number from fixed set of options in Excel

4. If you don’t want this, simply copy the random numbers and paste them as values.

5. Select cell C1 and look at the formula bar. This cell holds a value now and not the RAND function.

Worked Example:   How to generate random date between two dates in Excel

Randbetween

The RANDBETWEEN function generates a random whole number between two boundaries.

1. Select cell A1.

2. Type RANDBETWEEN(50,75) and press Enter.

3. If you want to generate random decimal numbers between 50 and 75, modify the RAND function as follows:

Post navigation

Previous Post:

Lock Cells in a Worksheet Excel

Next Post:

Countif function in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count total characters in a range in Excel
  • Excel MAX, MATCH and ADDRESS function illustration
  • How to remove trailing slash from url in Excel
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • Split numbers from units of measure in Excel
  • Calculate date overlap in days in Excel
  • Get days before a date in Excel
  • How to Calculate Age in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • How to calculate nth day of week in month in Excel
  • PV function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Net Present Value (NPV) in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles