Random function rand is mainly used in lottery program.
For example, there are 60 students in class 1 * *, and the student number ranges from 1 to 60, so the formula is = round ((1-rand ()) * 60,0).
Is a random number between 1 and 60.
Then every time you change the value of another cell, or press F9, its value will change once.