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.

The Excel functions for generating random numbers are RAND, RANDBETWEEN, and RANDARRAY. Generating random numbers in Excel is as easy as typing in the appropriate function, adding parameters (if ...

The basic random number generator in Excel is a function called RAND that generates a random real number between zero and one. To use it, simply include it in a formula or even call it on its own ...

Excel’s random number functions—`RAND`, `RANDBETWEEN`, and `RANDARRAY`—offer a robust set of tools for generating dynamic or static data. Whether you need simple decimals, ...

Try these tips to work faster and smarter in Excel. Max Productivity By JD Sartain, Oct 12, 2016 12:09 pm PDT. Image: Rob Schultz. ... The RAND function.

Now that you know how to use this function, let’s work out an expression that includes RANDARRAY() to return a set of random names. Figure A Use RANDARRAY() to return random values.