Using RAND() Function with Manual Calculation in Excel

ID: Q58365

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

SUMMARY

Creating an array of random numbers with the RAND() function with manual calculations enabled will fill the array with the same number duplicated in every cell of the array. You must have calculations set to automatic for the RAND() function to return an array of random numbers.

Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 15, 1999