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

Lookup and Reference Examples

  • Vlookup Examples in Excel
  • How to use Excel INDIRECT Function
  • Last row number in range
  • Multi-criteria lookup and transpose in Excel
  • Extract data with helper column in Excel

Data Analysis Examples

  • How to combine 2 or more chart types in a single chart in Excel
  • How to Use Solver Tool in Excel
  • How to Create Area Chart in Excel
  • Randomize/ Shuffle List in Excel
  • How To Filter Data in Excel

Data Validation Examples

  • Excel Data validation number multiple 100
  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation with conditional list
  • How To Create Drop-down List in Excel

RAND function: Description, Usage, Syntax, Examples and Explanation

by

What is RAND function in Excel?

RAND function is one of the Math and Trig functions in Microsoft Excel that returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.

Syntax of RAND function

RAND()

The RAND function syntax has no arguments.

RAND formula explantion

  • To generate a random real number between a and b, use:
Worked Example:   RAND vs RANDBETWEEN function examples in Excel

=RAND()*(b-a)+a

  • If you want to use RAND to generate a random number but don’t want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.

Example of RAND function

Steps to follow:

Worked Example:   Randomize/ Shuffle List in Excel

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Formula Description Result
=RAND() A random number greater than or equal to 0 and less than 1 varies
=RAND()*100 A random number greater than or equal to 0 and less than 100 varies
=INT(RAND()*100) A random whole number greater than or equal to 0 and less than 100 varies
Note: When a worksheet is recalculated by entering a formula or data in a different cell, or by manually recalculating (press F9), a new random number is generated for any formula that uses the RAND function.
Worked Example:   How to generate random times at specific intervals in Excel

Post navigation

Previous Post:

RANDBETWEEN function: Description, Usage, Syntax, Examples and Explanation

Next Post:

RADIANS function: Description, Usage, Syntax, Examples and Explanation

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
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • Get first name from name with comma — Manipulating NAMES in Excel
  • Remove first character in a cell in Excel
  • How to create email address from name in Excel
  • How to Check If A Cell Contains Specific Text in Excel
  • Steps to create Dynamic calendar grid in Excel
  • Calculate number of hours between two times in Excel
  • Add years to date in Excel
  • Display the current date and time in Excel
  • Convert Unix time stamp to Excel date
  • IRR function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles