So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

To use it, enter `=RAND()` into a cell, and Excel will return a random decimal value. If you need random numbers within a specific range, you can scale the output using a formula. For example: ...

If you are just looking to get rid of the numbers after the decimal point, using the INT function with your RAND function should do the trick. Open a new Microsoft Excel 2010 spreadsheet.

Excel uses the function RAND() to return a random and uniformly distributed number between 0 and 1, every time the worksheet is calculated. If you are analyzing how fluctuations in sales will ...

How to use the RANDBETWEEN function. Open Microsoft PowerPoint. Create a Table. In the cell where you want to place the result type =RANDBETWEEN(A2, B2).