SheetFX
≡
<< Go back to all functions

RANDBETWEEN

The RANDBETWEEN function in Google Sheets is a powerful tool to generate a random integer between two specified values. Whether you're simulating dice rolls, creating random test data, or conducting probability experiments, the RANDBETWEEN function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: RANDBETWEEN(low, high)

Parameters:

  • low: The lowest value for the random number.
  • high: The highest value for the random number.

Step-by-Step Tutorial

  1. Generating a random number:
    • Example: =RANDBETWEEN(1, 100)
    • Result: A randomly generated integer between 1 and 100.

Use Cases and Scenarios

  1. Simulating Games: Create random outcomes for game events.
  2. Random Sampling: Select a random subset of data for analysis.
  3. Probability Experiments: Simulate random events for statistical analysis.

Related Functions

  • RANDOM: Generate a random decimal between 0 and 1.
  • ROUND: Round a number to a specified number of decimal places.

Related Articles