98.8 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Generate randon numbers

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

Added by Meenesh on 3rd October 2006

More Excel hints and tips, like:

• Viewing two Excel 2010 Workbooks at the same time
• Move to edge of data block
• Hide data in Excel Worksheets