  >   >   >

RAND Function

Returns an evenly distributed random real number greater than or equal to 0 and less than 1

 by Charley Kyd, MBAMicrosoft Excel MVP, 2005-2014 The Father of Spreadsheet Dashboard Reports

Syntax

RAND()

Applies To

Excel 2003 and above

Remarks

RAND returns a 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.

Examples

Although RAND returns an evenly distributed number, it can be used with statistical functions to return results from a variety of distributions, as these examples illustrate. All charts return data from a column of 500 randomly generated values.

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

RAND Function for an Even Distribution RAND Function for Integers Between Two Values RAND & BETA.INV Functions for a Beta Distribution RAND & CHISQ.INV Functions for a Chi-Squared Distribution RAND & F.INV Functions for an F Distribution RAND & GAMMA.INV Functions for a Gamma Distribution RAND & LOGNORM.INV Functions for a Log Normal Distribution RAND & NORM.INV Functions for a Normal Distribution RAND & NORM.S.INV Functions for a Standard Normal Distribution RAND & T.INV Functions for a Left-Tailed Student's T Distribution RAND & T.INV.2T Functions for a Two-Tailed Student's T Distribution Other Help   