Rational
Generate a random number between 0 and 1.
Description
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.
Syntax
= RAND()
Parameters
(Empty Parenthesis)
Return Value
A random number between 0 and 1.
Key Notes
- 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.
Example
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.
Keep Reading Similar Functions:
ROUND
The ROUND function returns a number after rounding a supplied number to a specific number of digits like =ROUND(19.62159344,3) returns 19.621 (3 decimals).
RANDBETWEEN
The RANDBETWEEN function generates a set of random integers between two numbers, =RANDBETWEEN(10,50) returns always a random integer between 10 and 50.