# RANDBETWEEN

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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 functions returns an integer value. The first argument must be less than the second argument.
This is a volatile function with version 2.5 or later. For more information, refer to [Volatile Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-volatile).

## 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)`

## Version Available

This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.

## See Also

[RAND](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/FunctionRAND) \| [Math and Trigonometry Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsmathtrig)