**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.