Statistics
Make a random number
=RANDBETWEEN(1,100)How it works in Excel
- 1 is the lowest possible number.
- 100 is the highest.
- It changes every time the sheet recalculates.
- RAND gives a decimal between 0 and 1.
- Paste as values to keep the numbers.
The idea in general
It is like rolling a die with as many sides as you choose.
What I assumed
- You want a whole number from 1 to 100.
Check the result on your own data before relying on it.