In This Topic

RANDBETWEEN

In This Topic

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

RANDBETWEEN(*lower*,*upper*)

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 |

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.

For more information, refer to Volatile Functions.

Accepts numeric data for both arguments. Returns numeric data.

RANDBETWEEN(A1,B2)

RANDBETWEEN(10,20)

RANDBETWEEN(10,40)*100

INT(RANDBETWEEN(1,10)*100)

See Also