RANDBETWEEN

RANDBETWEEN

Synopsis

RANDBETWEEN(bottom,top)

Description

RANDBETWEEN function returns a random integer number between and including bottom and top.

  • If bottom is non-integer, it is rounded up.
  • If top is non-integer, it is rounded down.
  • If bottom > top, RANDBETWEEN returns #NUM! error.
  • This function is Excel compatible.

Examples

RANDBETWEEN(3,7).

See also

RAND, RANDUNIFORM.