Friday, July 17, 2009

How to Randomize with Excel

I have to randomize sampling several times a month, Microsoft Excel is the only tool for my Blackberry cannot work with that. Now I note that randomized input in Excel so I can export random figure anytime.

Software: MS Excel 2003
Formula: =RAND( )

I think if we want to get a randomized figure in specified range, we should input "=RAND( )*b-a", supposing b>a.

This Excel formula works good in Kingsoft Spreadsheets, too. Also you can randomize a figure by=randbetween(a,b).