"RAND" Function In Excel

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: