RAND

Generates a random decimal number between 0 and 1.

=RAND()

Example result:

0.638421

The result can change when Excel recalculates.

RANDBETWEEN

Generates a random whole number between two specified values.

Syntax

=RANDBETWEEN(bottom,top)

Example:

=RANDBETWEEN(1,100)

Possible result:

57

Real-World Uses

  • Random student numbers
  • Sample data generation
  • Testing worksheets
  • Random selection
  • Practice datasets

Practice

Generate:

  • 20 random numbers between 1 and 100
  • 10 random employee IDs
  • Random marks between 35 and 100
PreviousNext