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


Return random number within a range.


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


=RANDBETWEEN (bottom, top)


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.


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:

Generate a random number between 0 and 1 in Excel


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 »
Rounding to a specified number of digits in Excel


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 »