Microsoft KB Archive/58365

{|
 * width="100%"|

Using RAND Function with Manual Calculation in Excel

 * }

-

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 :

Technology :