Excel's Data Randomizer Function The basic random number generator in Excel is a function called RAND that generates a random real number between zero and one.