returns random integer between two values · from excel · excel: not yet compared · sheets: not yet compared

signature

RANDBETWEEN(bottom, top)

returns: number · volatile — recomputes on every evaluation

argument	required
bottom	required
top	required

usage

• =RANDBETWEEN(1, 100)

related

• ABS returns absolute value of a number
• ACOS returns arccosine of a number
• ACOSH returns inverse hyperbolic cosine
• ACOT returns the arccotangent of a number
• ACOTH returns the inverse hyperbolic cotangent
• ADD adds two numbers — sheets exposes the + operator as a function