Excel RANDBETWEEN function

Function              RANDBETWEEN

Description        Excel RANDBETWEEN function returns a random number between a given upper and lower range of numbers.

Syntax  RANDBETWEEN(bottom,top)

bottom  An integer representing the lower value of the range.

top  An integer representing the upper value of the range.

Usage Note:

• If bottom is greater than top then the RANDBETWEEN returns #NUM! error.