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 »