🎲 Random Generator

Goal: Generate random data for simulations.
RAND: Any decimal between 0 and 1.
RANDBETWEEN: Any whole number between specific limits.

Probability (0.0 to 1.0)
0.00000
Dice Roll (1 to 100)
--
Ready...

💻 Formula Structure

=RAND()
  • Args: None. Takes no inputs.
  • Result: A decimal >= 0 and < 1.
-- Select a generator...
...
Generated:
-

⚠️ Common Pitfalls

🚫 Volatile Functions
Both functions recalculate every time you change any cell in the workbook. This can slow down large files.
✅ Tip: Copy and "Paste Values" to freeze the numbers.
🚫 RANDBETWEEN Duplicates
It does NOT guarantee unique numbers. You might get the same number twice. Use SEQUENCE or SORTBY for unique random lists.