Make Random numbers in Excel

We will see how we may generate Random numbers in Excel

Using Formula

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

Using RAND Function

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

Float between 0 and 1

Using RAND Function

.Using RAND formula for the whole column

RAND Function

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

Multiplying by 100

We Multiple the formula with the desired number

RAND Function

Making Random float numbers between 0 and 100.

RANDBETWEEN Function

This formula returns an integer.

Two parameters

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

RANDBETWEEN Function

This formula returns an integer.