The RANDBETWEEN function takes twoarguments:bottomandtop.Bottomrepresents the lower bound for a random number, andtoprepresents the upper bound.

RANDBETWEEN includes bothtopandbottomvalues in the range of integers that may be returned.

Note: inExcel 365, theRANDARRAY functionis a more flexible alternative.

Excel formula: Random number from fixed set of options

For example, =RAND() will generate a number like 0.422245717.

RAND recalculates when a worksheet is opened or changed.

RANDARRAY Function

The Excel RANDARRAY function generates an array of random numbers between two values.

Excel formula: Random text values

The size or the array is specified byrowsandcolumnsarguments.

The generated values can be either decimals or whole numbers.

Excel formula: Random number between two numbers

Excel formula: Random value from list or table

Excel formula: Randomly assign data to groups

Excel formula: Random date between two dates

Article image

Article image

Excel RAND function

Excel RANDARRAY function