Using RAND() to Generate Randomly Distributed Integers (96746)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q96746 - Microsoft Excel for Windows 2.0|2.0
- Microsoft Excel for Windows 2.01|2.01
- Microsoft Excel for Windows 2.1|2.1
- Microsoft Excel for Windows 2.10c|2.10c
- Microsoft Excel for Windows 2.10d|2.10d
- Microsoft Excel for Windows 3.0|3.0
- Microsoft Excel for Windows 3.0a|3.0a
- Microsoft Excel for Windows 4.0|4.0
- Microsoft Excel for Windows 4.0a|4.0a
- Microsoft Excel for Windows 4.0c|4.0c
-
Microsoft Excel for Windows 5.0c|5.0c
- Microsoft Excel for Windows NT 5.0|5.0
- Microsoft Excel for the Macintosh 2.20|2.20
- Microsoft Excel for the Macintosh 2.2a|2.2a
- Microsoft Excel for the Macintosh 3.0|3.0
- Microsoft Excel for the Macintosh 4.0|4.0
- Microsoft Excel for the Macintosh 5.0|5.0
SUMMARY
Microsoft Excel does not include a built-in method for generating sets
of randomly sorted, uniformly distributed integers. The information
in this article describes how you can use the RAND function (which is
integral to Microsoft Excel) to create a set of this kind.
REFERENCES
"Microsoft Excel Function Reference," version 4.0, page 344
"Microsoft Excel Function Reference," version 3.0, page 191
"Microsoft Excel Functions and Macros," version 2.1 for Windows, page 396
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbinfo KB96746 |
---|
|