Microsoft Office Tutorials and References

In Depth Information

**BUILT-IN FUNCTIONS**

RANDBETWEEN Function

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.

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.