RAND function. Randomly obtains a small number greater than or equal to 0 and less than 1.(Microsoft Excel)
Randomly obtains a small number greater than or equal to 0 and less than 1.
However, for generating random numbers, the RANDBETWEEN function has a simpler formula and is easier to use in many situations.
How it works
=RAND()
Example Results
It is obtained randomly to the 1th decimal place.
This number is updated when recalculation occurs, such as when a cell is selected and removed.
For example, if you want to get 1 to 3 at random, the formula is as follows
=INT(RAND()*3)+1
If 3 is set to another number, the upper limit of the random number is increased.
If you remove +1, the random number will start from 0.
---