The RAND function
Returns a random decimal number from 0 up to, but not including, 1. It changes every time the sheet recalculates.
Syntax
RAND()Examples
B1=AND(RAND()>=0,RAND()<1)
| A | B | |
|---|---|---|
| 1 | TRUE |
B1=AND(RAND()*50+50>=50,RAND()*50+50<100)
| A | B | |
|---|---|---|
| 1 | TRUE |
B1=ISNUMBER(RAND())
| A | B | |
|---|---|---|
| 1 | TRUE |
Questions
How do I stop RAND from changing every time?
Copy the cells, then paste them back with Paste Special > Values (Ctrl+Alt+V, V, Enter). The formulas become fixed numbers.
How do I get a random number between two values?
For decimals, use =RAND()*(top-bottom)+bottom, so =RAND()*50+50 gives a number from 50 up to 100. For whole numbers, RANDBETWEEN is simpler.