Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »