RAND

Generate a random number between 0 and 1 in Excel
Returns a random number between 0 and 1

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:

Retrun random number within a range in Excel

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.

Read More »
Rounding to a specified number of digits in Excel

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

Read More »