Psychedelic trip with Excel

Here a fun way to use Excel and the Random number generator function.

This examples uses the RAND() function which generates a random number between 0 and 0.999999999999.

To create a number between 29 and 85.6 for example, you write

=RAND()*(85.6-29)+29

If it must be a integer between 29 and 86, then

=INT(RAND()*(86-29))+29+1

Or if you just want to use the latest from Excel use

=RANDBETWEEN(29,86)

 

There will be no screenshots as this is a surprise sheet.....

Download this example here.