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.

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

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 ...

The INDEX() function uses those six random numbers to return names from the Table, Names. Keep in mind that the list updates every time you calculate the sheet, which includes every time you do ...

There are two other methods to use the RANDBETWEEN function in Excel. Method one is to click the fx button on the top left of the excel worksheet. An Insert Function dialog box will appear.