This Function creates a random number between the given two numbers.
The Number will change each time the worksheet recalculates or when your press F9
Syntax:
=RAND()
or
=RAND()*10
or
=RAND()*(100-5)
Example:
Here is the detailed video tutorial for better understanding:
Comments