Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Return random numbers

 2003-03-18    Other    0    163

The worksheetfunction RAND() will return a decimal value greater than or equal to 0 and less than 1. Here are some examples on how to use this function :

=RAND()*100 Returns a decimal value between 0 and 100
=RAND()*(100-50)+50 Returns a decimal value between 50 and 100
=ROUND(RAND()*100,0) Returns an integer value between 0 and 100