deepcalc
DocsRANDBETWEEN

RANDBETWEEN

View as markdown/docs/functions/randbetween.md Ask Claude about this pageOpens Claude with this page's address

Returns random integer between two values.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number
  • Volatile: recomputes on every evaluation

Examples

  • =RANDBETWEEN(1, 100)

Syntax

RANDBETWEEN(bottom, top)
bottom
number required
top
number required
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.