Microsoft Office Tutorials and References
In Depth Information
If you wanted a cell to contain a randomly generated integer in the range from 1 to 9, you would use the
formula =RANDBETWEEN(1,9). Any value between 1 and 9 inclusive would be output by the formula. An
example is shown in Figure E-26.
RANDBETWEEN function used in cell A2
Assume that you copied and pasted the formula to generate a column of 100 numbers between 1 and 9.
Every time a value was changed in the spreadsheet, Excel would recalculate the 100 RANDBETWEEN
formulas to change the 100 random values. Therefore, you might want to settle on the random values once they are
generated. To do this, copy the 100 values, select Paste Special, and then select Values to put the values in
the same range. The contents of the cells will change from formulas to literal values.