Exceljet

Quick, clean, and to the point

Excel RAND Function

Excel RAND function
Summary 
The Excel RAND function returns a random number between 0 and 1. For example, =RAND() will generate a number like 0.422245717. RAND recalculates when a worksheet is opened or changed.
Purpose 
Get a random number between 0 and 1
Return value 
A number between 1 and 0
Syntax 
=RAND ()
Arguments 
Usage notes 
  • RAND calculates a new value each time the worksheet is calculated. To stop random numbers from being updated, copy the cells that contain RAND to the clipboard, then use Paste Special > Values to convert to text.
  • To get a random number that doesn't change when the worksheet is calculated, enter =RAND() in the formulas bar and then press F9 to convert the formula into its result.
  • To generate a set of random numbers in multiple cells, select the cells, enter RAND() and press control + enter.
  • To generate a random number between a and b, use this formula: RAND() * (b - a) + a

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.