We will see how we may generate Random numbers in Excel

We will use Formula for making random numbers of following type:

Float between 1 and 0.

Float between 0 and 100

Integer between 0 and 100

Use =RAND() for making a random number between 0 and 1.

.Using RAND formula for the whole column

We will use RAND function for numbers between 0 and 100.

We Multiple the formula with the desired number

Making Random float numbers between 0 and 100.

This formula returns an integer.

We add the lower and upper value and the function returns a value in between them

This formula returns an integer.