RANDBETWEEN Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

RANDBETWEEN is an Excel Math & Trig function. Returns a random whole number between two values.

RANDBETWEEN syntax

=RANDBETWEEN(bottom, top)

RANDBETWEEN is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try RANDBETWEEN yourself. No Excel install or sign-up needed to start.

What does the RANDBETWEEN function do in Excel?

Returns a random whole number between two values.

What is the syntax of RANDBETWEEN in Excel?

The syntax is =RANDBETWEEN(bottom, top). bottom: The lowest possible value to return; top: The highest possible value to return.

Where can I practice RANDBETWEEN online for free?

Open the free live spreadsheet on Cellgrids and try RANDBETWEEN yourself. No Excel install is needed and you can start without signing up.