Excel random number generator

There are times when we need random numbers generated in order to model or test data or worksheets.  Random numbers can be generated by two different operations: –

=RAND()

The RAND() function returns a value greater than zero and less than 1.

 

=RANDBETWEEN(low,high)

Using the above we specify the upper and lower limit of the numbers between which the random number should be returned.  The =randbetween() function allows for the return of numbers above 1.