# RANDBETWEEN

## Content

This function returns a random number between the numbers you specify.

## Syntax

`RANDBETWEEN(lower, upper)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *lower* | Lower number of two numbers between which a random number is chosen; this number must be less than *upper* |
| *upper* | Upper number of two numbers between which a random number is chosen |

## Remarks

This function returns a new random number every time the sheet is calculated.

This function returns an integer value. The first argument must be less than the second argument.

For more information, refer to [Volatile Functions](/spreadjs/docs/v16/formulareference/formulaoverview/functionsformula/volatilefunctions).

## Data Types

Accepts numeric data for both arguments. Returns numeric data.

## Examples

`RANDBETWEEN(A1,B2)`

`RANDBETWEEN(10,20)`

`RANDBETWEEN(10,40)*100`

`INT(RANDBETWEEN(1,10)*100)`