How to Use the RAND and RANDBETWEEN Functions in Excel (Random Data Generator)

How to Use the RAND and RANDBETWEEN Functions in Excel (Random Data Generator)

Need random numbers for testing or simulations? Excel’s RAND and RANDBETWEEN functions are perfect for generating random values quickly.

🔢 RAND Function

=RAND()

Returns a random decimal number between 0 and 1.

📌 Example:

=RAND() * 100

Gives a decimal between 0 and 100.

🎯 RANDBETWEEN Function

=RANDBETWEEN(bottom, top)

Returns a random whole number between two specified limits.

📌 Example:

=RANDBETWEEN(10, 50)

Returns a whole number between 10 and 50.

🔄 When to Use These Functions:

• Creating mock datasets
• Generating sample test scores
• Simulating lottery or random draws

⚠️ Note:

Both functions recalculate every time the worksheet updates. Use Paste Special > Values to freeze results.

Mastering RAND and RANDBETWEEN helps you create dynamic and realistic test data effortlessly in Excel.

For more insights, follow ScriptDataInsights.