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

RANDBETWEEN

Retrun random number within a range in Excel
Returns a random number between the numbers that you specify

Rational

Return random number within a range.

Description

The Excel RANDBETWEEN function generates a set of random integers between a lower bound (bottom) and an upper bound (top) number.
For example, =RANDBETWEEN(10,50) always returns a random integer between 10 and 50 (no decimal).

Syntax

=RANDBETWEEN (bottom, top)

Parameters

bottom – The low-end of value
top – The high-end of value

Return Value

A random integer between two given numbers

Key Notes

  • The RANDBETWEEN function generates a number between two value (bottom and top). For example, =RANDBETWEEN(1.5,5.5) always returns a random integer between 2 and 5.
  • RANDBETWEEN () is a volatile function, meaning each time a worksheet is recalculated or open, the random values change.
  • To paste static value press & enter F9 key directly in the formula bar that converts a formula into a numeric literal.

Example

If  user wish to insert random number with decimal format in a cell, like here we apply formula 

=RANDBETWEEN(B8,C8)+RAND() it return 75.30.

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 »
Generate a random number between 0 and 1 in Excel

RAND

The RAND function generates a number in the decimals format between 0 to 1, =RAND()*10+10 always returns a decimal number falling between 10 and 20.

Read More »