# RAND

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

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

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

### 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).