最新历史版本
:RAND-生成均匀分布的0-1之间的随机数 返回文档
编辑时间:
内容长度:图片数:目录数:
修改原因:
1. Overview编辑
| grammar | RAND() | Returns a uniformly distributed random number. Every time the worksheet is calculated, the function returns a new random value. |
|---|
2. Matters needing attention编辑
No parameters
To generate a random number between a and b, you can use the following formula: RAND()*(b-a)+a.
3. Examples编辑
| Formula | Result | Remark |
|---|---|---|
| RAND()*60 | Generate a random number greater than or equal to 0 and less than 60 | |
| RAND()*19 | Generate a random number greater than or equal to 0 and less than 19 | |
| RAND()*50 | Generate a random number greater than or equal to 0 and less than 50 |