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

Hints and tips home » Excel hints and tips » Random Numbers

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

Added by Garry on 2nd October 2006

More Excel hints and tips, like:

• Stop Formula Returning A "#DIV/0" Error
• Create a hyperlink navigation sheet
• Closing all your workbooks Quickly