Summary

The Excel RANDBETWEEN function returns a random integer between a lower bound and an upper bound. Microsoft documents that both endpoints are inclusive, which means the bottom and top values themselves can appear in the result. Like RAND, the function is volatile and recalculates whenever the worksheet recalculates.

RANDBETWEEN is designed for discrete outcomes rather than continuous ones. That distinction matters. If the model requires whole numbers such as random IDs, simulated die rolls, random day counts, or row-selection indexes, RANDBETWEEN is usually more direct than building the same behavior from RAND and rounding functions.

Syntax

=RANDBETWEEN(bottom, top)

RANDBETWEEN requires two arguments. bottom is the smallest possible integer and top is the largest possible integer. Both values can be typed directly or referenced from cells. The function is simpler than an equivalent INT(RAND()*...) pattern when the requirement is plainly "return an integer between these two bounds."

Arguments

• bottom - [Required] The minimum integer that can be returned.
• top - [Required] The maximum integer that can be returned.

RANDBETWEEN vs Related Functions

RANDBETWEEN and RAND often appear together in training material, but they serve different worksheet needs. The distinction is not about randomness itself; it is about the shape of the output.

If decimal precision is required, RANDBETWEEN is usually not the right starting point. In that case, either use RAND directly or generate scaled integers and divide them afterward only if a fixed decimal precision is acceptable.

Using RANDBETWEEN

RANDBETWEEN is common in temporary data generation because many test scenarios need realistic whole-number values such as counts, scores, rankings, or IDs. It is also useful in discrete simulations where the possible outcomes are countable rather than continuous.

Because the function recalculates automatically, it should be handled with the same care as RAND in finished workbooks. If the random outputs are meant to become fixed sample data, they should be copied and pasted as values after generation. Otherwise, unrelated sheet edits can change every simulated result.

• Use RANDBETWEEN for discrete random values.
• Use cell references for bounds when scenarios change often.
• Freeze the results if the random sample should stop changing.

Example 1 - Generate a Random Integer from 1 to 100

This example shows the standard behavior directly. Any integer between 1 and 100 can appear, and both endpoints are valid outcomes. That inclusive behavior is an important difference from RAND, whose upper limit is never actually reached.

=RANDBETWEEN(1,100)
// Possible results: 1 through 100

Example 2 - Simulate a Dice Roll

A six-sided die is a discrete model with six equally valid integer outcomes. RANDBETWEEN maps directly onto that structure, which makes the formula readable and mathematically aligned with the scenario.

=RANDBETWEEN(1,6)
// Possible results: 1, 2, 3, 4, 5, or 6

Example 3 - Reference the Bounds from Cells

Using cell references makes the formula reusable. If the lower or upper limit changes, the model can be adjusted by editing the bounds rather than rewriting the formula itself. That is especially useful in scenario testing.

=RANDBETWEEN(B1,C1)
// B1 = 50, C1 = 200
// Result is an integer from 50 through 200

Example 4 - Generate Integers in a Negative Range

Negative and mixed-sign ranges are valid. This is useful in models that simulate gains and losses, temperature variation, or any centered distribution where zero is not the only meaningful reference point.

=RANDBETWEEN(-10,10)
// Possible results: -10 through 10

One practical caution is bound ordering. If the lower bound exceeds the upper bound, Excel returns #NUM! instead of attempting to infer the intended direction. That is usually desirable because it exposes invalid input immediately rather than hiding it.

• Both endpoints are included in the result set.
• The function is volatile and recalculates automatically.
• Use RAND instead when the model needs continuous decimals rather than integers.

Conclusion Recap

• Summary: RANDBETWEEN returns a random integer between two inclusive bounds.
• Syntax: =RANDBETWEEN(bottom,top).
• Key behavior: The function is volatile and returns #NUM! when bottom is greater than top.
• Practical usage: Dice-roll logic, test data, random IDs, and discrete simulations.