RAND

The RAND function in Google Sheets generates a random number between 0 (inclusive) and 1 (exclusive). Whether you're simulating data, conducting statistical analysis, or creating randomized scenarios, the RAND function is extremely useful. Dive into our comprehensive guide to master its application.

Parameters

This function takes no parameters.

Step-by-Step Tutorial

1. Generating a random number:

   • Example: =RAND()
   • Result: A random decimal number between 0 (inclusive) and 1 (exclusive), recalculated on every sheet edit.

2. Scaling RAND to a custom range:

   • Example: =RAND()*(100-1)+1
   • Result: A random number between 1 and 100.

Use Cases and Scenarios

1. Data Simulation: Randomly generate sample data for testing or analysis purposes.
2. Random Scenarios: Create randomized scenarios in games, raffles, or simulations.
3. Statistical Analysis: Generate random values for Monte Carlo simulations or statistical modeling.

Related Functions

• RANDBETWEEN: Returns a random integer between two values, inclusive.
• RANDARRAY: Generates an array of random numbers between 0 and 1.

Related Articles

No related articles available for the RAND function.