# RANDBETWEEN

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