Generate a random number between 0 and 1.
The Excel RAND function generates a number in the decimals format between 0 to 1.
For example, =RAND()*10+10 always returns a decimal number falling between 10 and 20, i.e., 10.00..1 or 19.999.
A random number between 0 and 1.
- The RAND function generates a decimal number between 0 to 1 useful in returning fractional number.
- RAND() is a volatile function, meaning each time a worksheet is recalculated or open, the random values change.
If user wish to insert random number with decimal in a cell, we can apply formula
=RANDBETWEEN(50,100)+RAND() it return 98.58354656.
We can also get negative decimal format in a range without repeats, for this we use formula,
=RAND()-2.2 it return different numbers in each cell exclude repeats.